Microsoft Fabric Training

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…

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.

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…

Can anyone tell me why Q&A setup option is disable in my power bi report which is live connected to a semantic model

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…

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…

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…

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…

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:…

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.

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…

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…

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…

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…

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

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

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…

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…

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…

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,…