Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Udantha
New Member

We have recently learned that PowerBI does not do a great job of URL-encoding key values.

We have recently learned that PowerBI does not do a great job of URL-encoding key values.

 

Characters that can be used in space and externalId fields without breaking PowerBI expand functionality:

Alphanumeric characters: a-z A-Z 0-9
Unreserved characters: - _ . ~
Subset of reserved characters - no guaranties that they will always work: ! * ' ( ) ; : @ & = + $ ,

 

Is it possible to implement it to support all special characters as well?

2 REPLIES 2
Udantha
New Member

Hi @v-zhengdxu-msft 

Thank you for the explanation. Is there any planned development to overcome this limitations issue in the future or possibly a workaround?

v-zhengdxu-msft
Community Support
Community Support

Hi @Udantha 

 

Power BI does support a range of characters in URLs, including alphanumeric and certain reserved characters, by utilizing URL encoding standards. However, it's important to note that while many special characters are supported, there are specific encoding requirements and limitations to ensure compatibility and functionality.

Regarding your specific question about supporting all special characters, while Power BI strives to accommodate a wide range of characters, there are inherent limitations due to web standards and the OData protocol Power BI uses for its queries. Some characters may require specific encoding or may not be supported in certain contexts due to these constraints.

This is detailed in the Power BI documentation on URL filters, which you can review here:
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.