Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

(1) ShareShare
ReportReport
Posted on by 158

Is there a possibility to receive data from a "Power BI Data Flow" in to Flow (Power Automate)?

 

My Use Case is to enter coming from a SAP BW and other sources via "Power BI Data Flow" in to a SharePoint List.

Currently the Result of the Query is Download Manually from Power BI and copied in to SharePoint.

 

I have updated Excel Tables in to SharePoint so far but I did not see any option utilising "Power BI Data Flow's" so far.

 

I have seen that Power Query Data Flows can be used in Azure directly, but here I would need help if that would be an option.

 

Thanks

Fritz

  • Jöse Profile Picture
    Jöse 4 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    Jse_0-1717159502251.png

     

  • Jöse Profile Picture
    Jöse 4 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    Hi @xsg13 

    Your solutions sound exactly how i need to solve my issue with getting data from PowerBI, but do you have an example of how you can share. I have difficulties in the step from dataflow refresh and then triggering a dataset refresh - shouldn't there be a delay from the start of the dataflow refresh to the dataset refresh, since you want your dataset to be refreshed based upon the newly refreshed dataflow data?

    next how do you get your data extracted from the PowerBI dataset?

  • xsg13 Profile Picture
    xsg13 30 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    One workaround is to have an intermediary Power BI dataset.  If you have your Dataflow consumed into the PBI Dataset, you can pull the data into the Power Automate from there with the PBI connector.

    You will need to then create another Power Automate to trigger a Power BI Dataset refresh at the successful completion of a Dataflow Refresh so the data stays up to date.

    This works, but it is not convenient.

  • ffritz Profile Picture
    ffritz 158 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

     

     

    No, I did not have time yet (since it's currently not that high priority).

    What I planned to try next is, to create an Azure Storage Account, connect the Workspace (with the DataFlow) to it.
    Which then gives me a CSV File with the result of the DataFlow on the Azure Storage Account. 
    This I then would try to access  from Flow.

    But I do not know yet if it will work, and I wont have time to try it for some time.

  • ffritz Profile Picture
    ffritz 158 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    No, I did not have time yet (since it's currently not that high priority).

    What I planned to try next is, to create an Azure Storage Account, connect the Workspace (with the DataFlow) to it.
    Which then gives me a CSV File with the result of the DataFlow on the Azure Storage Account. 
    This I then would try to access  from Flow.

    But I do not know yet if it will work, and I wont have time to try it for some time.

  • xsg13 Profile Picture
    xsg13 30 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    @ffritz 
    Did you have any luck in finding a way to do this?

  • ffritz Profile Picture
    ffritz 158 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    Maybe this helps as well

    here an example how to connect to a Power BI Data Flow Source in M-Code (e.g. from Power BI Desktop)

    Source = PowerBI.Dataflows(null),
    #"ad33b348-02a5-4182-baa6-48230ce95ce5" = Source{[workspaceId="ad33b348-02a5-4182-baa6-48230ce95ce5"]}[Data],
    #"fec414e9-a4e4-4e3f-a37d-3296f4f19117" = #"ad33b348-02a5-4182-baa6-48230ce95ce5"{[dataflowId="fec414e9-a4e4-4e3f-a37d-3296f4f19117"]}[Data],
    ResponsibilityMatrix1 = #"fec414e9-a4e4-4e3f-a37d-3296f4f19117"{[entity="ResponsibilityMatrix"]}[Data],



  • ffritz Profile Picture
    ffritz 158 on at
    Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    here the description of Power BI Data Flows 

    https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview

     

    here the description how the results of the Data Flows's are stored in the Azure Data lake

    https://docs.microsoft.com/en-us/power-bi/service-dataflows-azure-data-lake-integration

     

    In general the PBI Data Flow is like a Power Query that runs in the cloud and stores the result there for PBI Reports to use.

     

    Rgds

    Fritz

  • Re: Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

    Hi @ffritz ,

     

    Could you please explain more details about the Power BI Data Flow that you mentioned?

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics