Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dinosainsburys
Frequent Visitor

How to export Power BI output to Excel through Power Automate?

Right now, I have a flow which gets the data from a PBI table and creates a CSV file from it and saves it to a SharePoint location. I want it to go from PBI to Excel or if not CSV to Excel but I have been having difficulty doing it. I have looked at some of the actions but they require an API key which I cannot get as my organisation does not allow me to use them kind of external apps. Any suggestions, please? I would prefer to use Excel as I can do data transformations as needed. 

1 ACCEPTED SOLUTION

No, a delay won't help as you never know how long it will take this time.  You need to poll the refresh history and check if the latest entry has an end date (meaning it's done) or not (meaning it is still in progress).

 

Personally I use a custom action with enhanced refresh and request ID.

 

lbendlin_0-1709646839998.png

 

View solution in original post

7 REPLIES 7
lbendlin
Super User
Super User

- Run the DAX Query

- stuff the "First Table Rows"  into an Excel table

 

Done.

 

If you want this to be fast you would need to use the Graph API.  For a pedestrian solution you can use the default "Add a row to an Excel table"  action.

So my flow is currently like this

 

Run a query against a dataset (PBI) -> Add a row into a table (Excel)

 

I haven't seen anything update on my Excel table? 

You need to loop over the first table rows.

 

You need to have named table in Excel 

 

Show your flow.

dinosainsburys_0-1709644578068.png

 

I got some bad news for you. "Refresh a dataset" is asynchronous. It doesn't wait for the completion. Your queries are running against the old dataset.

 

Show the details of the last step. I don't see where Excel comes into play 

Oh no! 😞 So how can I make sure so it works against the latest data? Could I add a delay, is that what you mean? 

No, a delay won't help as you never know how long it will take this time.  You need to poll the refresh history and check if the latest entry has an end date (meaning it's done) or not (meaning it is still in progress).

 

Personally I use a custom action with enhanced refresh and request ID.

 

lbendlin_0-1709646839998.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.