Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need to export a report to PDF and I'm using PowerAutomate to send reports based on a filter.
I've tested with diferent filters using the instructions here and it works fine:
https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to#filters
To be concrete, I know that I need to add ?filter= Table/Column <comparison> <value> in the URL to get the exact report I need.
I have however an issue with a specific filter that is coming from a table that is not a unique word (let's call it The Table). I do not find a way to create the URL that allows me to filter according to this, I've tired the following:
?filter='The Table'/OPP-ID eq 'ABCE'
?filter="The Table"/OPP-ID eq 'ABCE'
?filter=The Table/OPP-ID eq 'ABCE'
None of these worked.
Any suggestion?
Thanks!
Solved! Go to Solution.
Nevermind, the answer is this one: ?filter=The_x0020_Table/OPP-ID eq 'ABCE' (if it is of interest)
Nevermind, the answer is this one: ?filter=The_x0020_Table/OPP-ID eq 'ABCE' (if it is of interest)