I had a successful flow where I could pass in a filter parameter and use Power Automate to iterate through a Power BI report page (each with a different filter) and export as PNGs in SharePoint.
I then linked these PNGs to a PowerPoint slide pack so it would update from the latest PNG copies on SharePoint.
I did it this way as Power Automate doesn't allow you to export the same Power BI page more than once in a given step, and I didn't want to have 20 identical hidden Power BI pages with preset filters.
However, I had to do a change to my Power BI model to make it DirectQuery of the dataset ... and since then it now displays "Error fetching data for this visual" everywhere.
This Power BI report still opens perfectly well in the Workspace and allows me to export to PowerPoint or PDF without displaying this error.
I went back to an old version of the Power BI model and published and the Power Automate flow worked.
If I don't change anything (no extra measures, no calculated columns or anything else) and change the Power BI to Direct Query ... the Power Automate flow reverts to "Error fetching data for this visual" again.
Any suggestions ?
I have tried updating all my Power BI connections in the flow to ensure its not some permission issue from Power Automate.
I have seen similar threads
https://community.powerplatform.com/forums/thread/details/?threadid=adc58d7b-08eb-4174-95be-021f4d51cd00
36
Share
Report
All responses (
Answers (
