Forum Discussion
Need help with PowerBI report export via Power Automate
You still have a space in the table name after the word Portal.
Please remove the space and try again.
So I added &filter='Portal Revenue'/'Driver Name' eq 'Andrew Parker' to the end of that URL for that report and when it loaded (it changed the full URL some on its own), it still loaded the report for All Drivers and not for Andrew Parker.
ChrisAZ
Okay so this tells us that the filter condition is not working, so no matter what you do in Power Automate this isn't going to work until the filter condition is corrected.
I recommend reviewing the documentation about query string parameter filtering:
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
THe next thing I would try is encoding the spaces:
&filter=Portal_x0020_Revenue/Driver_x0020_Name eq 'Andrew Parker'Can you also send a screenshot of the semantic model so I can see what the table and column look like in there?
If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution.
By encoding the spaces, meaning add the space in before the name?