cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Winniethewinner
Helper III
Helper III

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

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. 

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

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.

v-jianboli-msft
Community Support
Community Support

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. 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.