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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TinyElephant
Helper III
Helper III

Schedule Automated Data Exports from a third-party Power BI App

Hello,

 

I wanted to know what could be alternatives to manually exporting the tabular data of some visuals out of a premium workspace report every month (by filtering).

TinyElephant_1-1668492828695.png

 

TinyElephant_0-1671074303832.png


Exporting Summarized data or Data with Current Layout (for tables) since the underlying data is private. I am not the owner of the report and cannot make/influence modifications to the original report.

I saw this Power Automate workflow "Run a query against a dataset" but I'm not sure if the "Query text" can actually interrogate the dashboard/report (underlying dataset)? Any suggestion is appreciated.

 

TinyElephant_2-1668493152257.png

 

3 REPLIES 3
TinyElephant
Helper III
Helper III

Does anyone have any suggestion on how to download the "Data with current layout"? Any web scraping tool, powershell script, which can help to go to the report page and download it.

GilbertQ
Super User
Super User

Hi @TinyElephant 

 

Yes this can certainly be done.

 

In my blog post below I explain how to get the DAX query from a PBIX

 

Which you can then use in Power Automate

Exporting a Power BI Visual data to a CSV File in SharePoint - FourMoo | Power BI | Data Analytics





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello @GilbertQ ,

Thanks for the response. However, I do not have edit access (cannot download) to the dataset or report. So, I'm not sure how you can open it in Power BI Desktop and run the Performance Analyzer.
But I can manually download the visual/filtered visuals by Export Data --> Summarized data to Excel as seen in the original post.


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.