Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Jumping off from this example:
http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically
I can successfully get this filter URL parameter to work:
That works fine because my table is named Date and my field is named Date.
If I try to filter on a field or a table with a space, then it fails:
?filter=My Table/My Field eq '2014'
Renaming table names and field names to remove spaces is not feasible as it breaks existing reports and makes the model less user friendly/readable. Is this truly a limitation in Power BI Service and there's no way to escape out the space?
what do you in below situation when ,
Table Name = "Team (department)"
Is this correct way of doing is ?
filter=Team_x0020_(department)/Team eq 'IT'
In case people still end up here looking for an answer, this is explained in the MS Documentation:
Thank you, that's a great tip. Worked in the Power BI export function in Power Automate too
Is there a way to filter the "Publish to web" URL? I've tried adding &filter=Table1/ZipKey eq '00001' but it doesn't work on this URL:
but it does work on
I need to embed this report within a webpage.
Has anyone heard any news on a fix?
There is a limitation - table or field names cannot have spaces , at least according to the post..
Try using %20 instead of the single space character. I believe these are substitutes in URLs.
Hello,
I have a situation where I need to send the filter values from Power BI report published on Power BI service to report builder as parameter values through URL. Do you have any idea on this? If yes, could you please help me out.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.