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.
Hi there,
I created a salesforce URL link, which takes the user to a PowerBI report. But I'd like to auto-filter the power BI report based on the account the user is viewing.
The field in Power BI is called: Branch Agency (note: the original name from the query is called Branch_Office and there's a rename to Branch Agency in Power BI). The values contain for example: 012345 abccompany. In Salesforce it's the fields of ClientID_c and ClientName_c.
The filter formula I wrote: ?filter=Branch Agency eq '"ClientID_c+' '+ClientName_c"'"
But it didn't work, i.e. it goes to Power BI report but no filter applied. Can anyone please help? Thank you.
Solved! Go to Solution.
Hi @Winniethewinner ,
The phrase "column name cannot include a space" means that the column name cannot be empty or have only spaces or begin with a space, but the rest of the cases are allowed to include spaces.
URL filters support most special characters in field values, but some also require escape codes. For example the Escape Code of "a space" is %20.
Besides, when you use a URL with spaces and other special characters in it, browsers may automatically replace them with standard escape characters.
For more details, please refer to:
Standard URL escape characters - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Winniethewinner ,
The phrase "column name cannot include a space" means that the column name cannot be empty or have only spaces or begin with a space, but the rest of the cases are allowed to include spaces.
URL filters support most special characters in field values, but some also require escape codes. For example the Escape Code of "a space" is %20.
Besides, when you use a URL with spaces and other special characters in it, browsers may automatically replace them with standard escape characters.
For more details, please refer to:
Standard URL escape characters - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Winniethewinner ,
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Besides, here are several links about URL filter, please refer to:
Power BI Report URL filter improvements | Microsoft Power BI Blog | Microsoft Power BI
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I found a similar post and I have exactly the same issue: https://community.powerbi.com/t5/Desktop/Dynamic-URL-filter-based-on-value-from-Salesforce/td-p/1817...
My question is: if the field name in Power BI contains a space, for example
PowerBIreporturl?filter=Branch Agency
can it still be filtered? I found somewhere saying column name cannot include a space.
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.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |