Answered

Extract Power BI content using Power Automate / Flow

(0) Share

Report

Posted on by hecval

I am trying to create a flow that allows me to automatically extract some of the data included in a report that I published in Power BI Service.

When I try to get this data into a Flow step, it only lets me obtain the dataset "Body", which appears to be Null. Is there a possibility to automatically extract specific data from a Power BI report or dashboard, like a table or its visualizations?

Thank you

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ScottShearer 25,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@hecval

What Power Automate action are you using to extract the data from Power BI? If you are using the Refresh a Dataset connector, I don't believe that it returns data to you (at least the documentation doesn't say that it does...).

I am not aware of any "out of the box" method of pulling data into Flow from Power BI. There may/may not be a way to get there by calling the API via an HTTP action. Using the HTTP action is a Premium action and is not included with the Office 365 license.

Was this reply helpful? Yes No
hecval 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ScottShearer

Indeed, I am using the "Refresh a Dataset" connector.
I couldn't find anyway to return data neither, but when I move to the next step of my flow (in my case Send an email notification V3), it lets me include something called "Body" from the "Refresh a Dataset" connector, and I couldn't find what this is. Do you know where I can find any documentation about it?

Thanks

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@hecval

Documentation can be found here

Was this reply helpful? Yes No