Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All
Need some help about this queries in power bi. I have a report (I only have read/view) rights on it and I want to query it via url.
I have create my URL, the report loads but nothing is filtered.
I saw that you need to be careful of spaces in the query and all thoose limitation and as far I can see I got that right. Out of option so looking is there any additional tip I should try.
Here is my table name with its column name and the filter I am trying. I just dont get it why its not filtering.
https://app.powerbi.com/groups/<someprivateurl>?filter=MIM_MART_FACT_DFO.DM_F_DIP_TRANS_POSITION_LOSS_PREVENTION/Locations eq 'GENN'
I dont get it. You mean I should replace the table name underscores ? like this:
MIM_x005f_MART_x005f_FACT_x005f_DFO.DM_x005f_F_x005f_DIP_x005f_TRANS_x005f_POSITION_x005f_LOSS_x005f_PREVENTION
its not working
Maybe it's time to simplify your table name?
not the owner, dont have access to source table. Maybe I'l try to ask.
you need to encode the underscore.
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
I am looking at this article but i dont see encoding for an _ in the table name. I'l search a bit more
_x005f_
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |