Export To File for Power BI Reports Error

Like (0) Share

Report

Posted on 28 Mar 2025 20:43:07 by gstredny

128

I am trying to export graphs from my Power BI report and then save them as files then upload those files to put into a Word Document for a report all via Power Automate.

I keep getting this error though when using the Export to File for Power BI Reports:

I have verified my column name in that LabAnalysis table is assetid too:

Any help would be appreciated!

Categories:

Business Process Flows

All responses (3)

Answers (0)

lbendlin 7,761 Super User 2025 Season 1 on 31 Mar 2025 at 22:39:25

Like (0)

Report

Export To File for Power BI Reports Error

Your table name has "weird" characters. You need to encode these.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters
gstredny 128 on 31 Mar 2025 at 14:46:17

Like (0)

Report

Export To File for Power BI Reports Error

Thank you, I took out this filter:

{
"table": "ANALYTICS LabAnalysis_sv (Pivoted)",
"column": "assetid",
"operator": "eq",
"value": "@{triggerOutputs()?['body/AssetID']}"
}

And that was successful. Do you have any tips on how to get the filter to work. I want it to filter by the dynamic content that comes in from the trigger.
Suggested answer

MS.Ragavendar 1,038 on 29 Mar 2025 at 09:04:46

Like (1)

Report
Export To File for Power BI Reports Error

@gstredny,

Temporarily remove all filters in Power Automate, Run the flow again. If the export is successful then filter is the issue.

If you’re passing a dynamic filter value, ensure it's not blank

if(empty(variables('FilterValue')), null, variables('FilterValue'))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item