topic Salesforce URL link to open and filter Power BI field - field name contains blank in Developer

Salesforce URL link to open and filter Power BI field - field name contains blank

Winniethewinner — Mon, 05 Dec 2022 14:58:15 GMT

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.

Re: Salesforce URL link to open and filter Power BI field - field name contains blank

v-jianboli-msft — Tue, 06 Dec 2022 06:05:51 GMT

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.

Re: Salesforce URL link to open and filter Power BI field - field name contains blank

Winniethewinner — Mon, 12 Dec 2022 21:51:05 GMT

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/1817448

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.

Re: Salesforce URL link to open and filter Power BI field - field name contains blank

v-jianboli-msft — Tue, 13 Dec 2022 07:17:43 GMT

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.