SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,070 questions
0 answers
Error when setting destination in Copy Data activity (MS Fabric)
Hi all, In my Fabric workspace, I have a pipeline with a "Copy Data" activity. The source is a lakehouse. I am trying to set the destination to be SQL Server. I have put in the server name, username and password. I also checked the checkbox…
asked 2024-11-23T16:16:39.4233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 6%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJU%3C/text%3E%3C/svg%3E)
John Uzoma
20
Reputation points
commented 2024-11-23T18:08:57.6666667+00:00
Erland Sommarskog
113.1K
Reputation points MVP
1 answer
In MS fabric users able to view data but cannot download it
In MS Fabric, I want users to be able to view data in the workspace but not be able to download it. Please provide clear steps, along with links to verify the authenticity of the solution provided.
asked 2024-11-11T11:51:04.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 11%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jain, Shreyans
0
Reputation points
commented 2024-11-13T18:06:00.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram
1,510
Reputation points Microsoft Vendor
1 answer
How can I check if someone else has modified the pipeline I created in Microsoft Fabric?
I am the admin of a workspace in Microsoft Fabric and have created a pipeline within this workspace. I want to monitor any changes made to this pipeline and identify if someone other than me has modified it. Specifically, I’m looking for a way to track…
asked 2024-10-25T14:48:32.5466667+00:00
Jain, Shreyans
0
Reputation points
commented 2024-11-13T16:08:24.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
9,420
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
asked 2024-11-12T10:15:57.1266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 15%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Ketan Bharat | MAQ Software
40
Reputation points
commented 2024-11-12T12:46:56.34+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 21%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Syed Saleem Peera
8,340
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to use a private key to connect to an SFTP datasource in AppFabric?
I am creating my first data factory in app fabric. One feature I found missing is that I cannot connect to a SFTP source unless, I have basic authentication. In the previous version of Azure Data Factory, I had an option of selecting the authentication…
asked 2024-11-08T19:27:39.11+00:00
Abhijit Shrikhande
377
Reputation points
accepted 2024-11-11T15:07:48.0566667+00:00
Abhijit Shrikhande
377
Reputation points
1 answer
How cn i restrict someone from not downloading any data from Fabric Lakehouse or Fabric warehouse
As a data admin, i want to control data access for a user in your Microsoft Fabric Warehouse. The goal is to allow this user, who has a Contributor role, to view data directly in the workspace without being able to download it as a file. This scenario…
asked 2024-11-05T05:24:13.73+00:00
Jain, Shreyans
0
Reputation points
commented 2024-11-07T18:46:34.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
17,525
Reputation points Microsoft Vendor
1 answer
How cn i restrict someone from not downloading any data from Fabric Lakehouse or Fabric warehouse
As a data admin, i want to control data access for a user in your Microsoft Fabric Warehouse. The goal is to allow this user, who has a Contributor role, to view data directly in the workspace without being able to download it as a file. This scenario…
asked 2024-11-05T05:14:23.56+00:00
Jain, Shreyans
0
Reputation points
commented 2024-11-06T03:04:55.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 2%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hari Babu Vattepally
715
Reputation points Microsoft Vendor
1 answer
Microsoft Fabric Data Factory - MS Graph API - Groups/Users - Unable to reference response paging attribute
I am trying to get all groups and users from MS Graph. These both use paging (limit 100 records per page). To get the next page I need to reference an attribute in the previous repsonse. However, the attribute has '@' and '.' in it... how do I reference…
asked 2024-10-18T14:59:57.8433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 27%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Laron Lemon
0
Reputation points
answered 2024-10-18T20:43:35.7166667+00:00
Amira Bedhiafi
26,971
Reputation points
2 answers
How can I trigger Fabric Notebook or Fabric data pipeline from Azure Data Factory?
I am trying to trigger fabric notebook via ADF via API calls but it is throwing an error. Details: https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-public-api#run-a-notebook-on-demand Using above article's API Error:…
asked 2024-10-11T09:43:46.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 44%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sunay Pistulkar
5
Reputation points
commented 2024-10-15T04:11:08.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
11,465
Reputation points Microsoft Vendor
2 answers
Please suggest a way to replicate or transfer data from azure sql database to fabric lakehouse in realtime
Need to transfer large amount of data from azure sql database to fabric lakehouse in relatime.
asked 2024-10-03T19:00:08.4266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 81%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AGP
40
Reputation points
commented 2024-10-08T04:58:04.5666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,585
Reputation points Microsoft Vendor
2 answers
How to bring real-time data from Azure sql DB to Microsoft fabric Lakehouse without using Fabric Mirroring and scheduling of pipelines.
I need to bring real time data from Azure SQL database to Microsoft Fabric Lakehouse. I checked for the option of Fabric Mirroring but there are many challenges in it so i need an alternative solution with realtime data availability. Please help me with…
asked 2024-10-04T10:49:14.6533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jothi Lakshmi P M
0
Reputation points
answered 2024-10-04T11:28:52.81+00:00
Nandan Hegde
32,656
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Salesforce Data in Microsoft Fabric with Organizational Account
Hello, I am using Dataflow Gen 2 in Microsoft Fabric to ingest data from Salesforce using the Salesforce Objects connector. The connection is made using an Organizational Account (OAuth 2.0). However, I noticed that there's no option to provide…
asked 2024-09-27T18:19:11.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 79%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Syed Umair Hasan
130
Reputation points
accepted 2024-09-27T19:52:20.47+00:00
Syed Umair Hasan
130
Reputation points
2 answers
How to sign up to microsoft fabric?
Hi, I'm trying to sign up for Microsoft Fabric using my school student account, but I keep getting stuck on the first step where I sign in. Either nothing happens when I click, or I get redirected to the landing page which keeps loading indefinitely. I'm…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXG%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 11%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
1 answer
Job Queueing with Microsoft Fabric
Hi Team, We have a scenario where we need to move data from Oracle to One lake on demand. We are having a table where a user enters the configuration similar to batch and on each insert it needs to trigger the data movement pipelines .However I don't…
asked 2024-09-16T11:41:45.1066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
45
Reputation points
commented 2024-09-18T14:49:24.5666667+00:00
Smaran Thoomu
17,525
Reputation points Microsoft Vendor
2 answers
Power BI /Tableau Dataset Need to refresh
Hello Team, I have requirement, Where the Power BI/Tableau Dataset need to refresh after the ADF Pipeline ran successfully without any manual Interference. How this can be achievable Regards Rohit
asked 2024-08-26T16:25:03.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rohit Kulkarni
691
Reputation points
commented 2024-09-03T21:27:47.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
31,121
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
can we add multiple containers in Microsoft Fabric Data Lake house?
I want to add one more container in Microsoft fabric lake house, as per my knowledge we can add only one container but i am curious to know can we add multiple containers in Microsoft fabric lake house
asked 2024-08-26T09:48:53.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 92%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gnana Sai krishna
80
Reputation points
accepted 2024-08-27T16:00:34.8633333+00:00
Gnana Sai krishna
80
Reputation points
1 answer
Error When Creating Managed AirFlow in Azure Data Factory
I attempted to create a Managed AirFlow environment in Azure Data Factory, but I encountered the following error: "Failed to save Airflow1. Error: Failed to save integration runtime. Airflow IR creation is not allowed. Please create new Data…
asked 2024-08-20T05:37:14.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 18%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ahwan Mishra
140
Reputation points
commented 2024-08-27T09:19:17.9766667+00:00
NIKHILA NETHIKUNTA
3,585
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Couldn't able to see the hierarchy in the MS Fabric files on copying the files from blob to fabric using ADF copy activity
I'm trying to ingest the files(txt) from blob to fabric files. I have the hierarchy in blob like container/main_folder/sub_folder/Date_folder/files. When I use the ADF copy activity to copy all the files from the Date_folder to Fabric files. I can't able…
asked 2024-08-10T13:54:52.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 48%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Siva Reddy
40
Reputation points
accepted 2024-08-14T07:13:17.71+00:00
Siva Reddy
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Fabric datawarehouse unable to write data to cloud SQL
Hi, Im trying to setting up Microsoft Fabric to write SQL data to Azure cloud SQL(private endpoints) by below approach. Fabric --> Azure Firewall --> OPDG VM --> Azure SQL. But im getting below error. Note: OPDG is install in the cloud VM where…
asked 2024-08-12T08:50:23.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 47%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mahesh
20
Reputation points
edited the question 2024-08-13T10:06:07.51+00:00
PRADEEPCHEEKATLA
90,241
Reputation points
1 answer
One of the answers was accepted by the question author.
Can't run Azure Fabric Notebook cells in VS Code
Hey, I am trying to get Azure Fabric Notebook to work with VS Code using the Synapse Visual Studio Code Extension as described in: https://learn.microsoft.com/en-us/fabric/data-engineering/setup-vs-code-extension I managed to install the prerequisites,…
asked 2024-08-02T08:59:58.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 73%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Mike Cornelis
20
Reputation points
accepted 2024-08-12T06:29:04.17+00:00
Mike Cornelis
20
Reputation points