Export To File for Power BI Reports Error

(0) Share

Report

Posted on by gstredny

134

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:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 6,961 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
gstredny 134 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
lbendlin 8,701 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No