Share via

Is there a way to connect azure data factory to power Bi dataflows ?

Amar Agnihotri 926 Reputation points
2022-06-16T10:08:28.457+00:00

Hi,
I want to pull data to datalake gen 2 from Power Bi dataflows using Azure data factory pipeline. Is there a way to do that ?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,637 questions
Accepted answer
  1. PRADEEPCHEEKATLA 90,646 Reputation points Moderator
    2022-06-17T10:28:41.69+00:00

    Hello @Amar Agnihotri ,

    From the screenshot above, looks like you are trying to connect Azure Data Lake Gen2 with Power Bi Data Flows.

    As a prerequisites: To bring your own ADLS Gen 2 account, you must have Owner permission at the storage account layer. Permissions at the resource group or subscription level will not work. If you are an administrator, you still must assign yourself Owner permission.

    For more details, refer to Configuring dataflow storage to use Azure Data Lake Gen 2.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HASNINE MAZAHARUL MIRZA 5 Reputation points
    2024-02-22T16:38:48.3233333+00:00

    Power BI and Azure Data Factory serve different purposes within the data analytics and business intelligence landscape. Power BI is primarily a data visualization tool that enables to connect with different Azure services but not an Azure Data Factory, Because ADF focuses on orchestrating and automating data workflows for data integration and transformation and there is no storage solution with ADF. To establish a connection between Power BI and Azure Data Factory, a common approach is to utilize Azure services such as Azure Data Lake Storage or Azure SQL Data Warehouse as intermediate storage for processed data. ADF can be employed to orchestrate data pipelines, performing ETL (Extract, Transform, Load) operations, and depositing the data in the designated storage. Power BI, in turn, can then connect to these Azure storage solutions as a data source to create visualizations based on the processed data. organizations can harness the strengths of both Power BI and Azure Data Factory to build end-to-end data analytics solutions, ensuring seamless data flow from source to visualization where they can store the data at any storage services like Blob, ADLS Gen2, or Tables. In summary, while direct integration between Power BI and Azure Data Factory might not be applicable in the traditional sense, a well-architected solution leveraging Azure services can facilitate effective collaboration between these platforms to deliver robust and comprehensive analytics capabilities.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.