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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rogerunholz
New Member

Power BI Report Builder handling parameters with special characters

Dataset

 

rogerunholz_0-1635935167702.png

 

 

Power BI Report Builder (version 15.7.1740.1)

 

Dimension-column "Eigentümer ID" contains special character (ü) and is used as a parameter:

rogerunholz_1-1635935167718.png

 

 

 

 

The query designer generates the following DAX-query (please note the special character 'ü' in the parameter @EigentümerEigentümerID):

 

rogerunholz_2-1635935167732.png

 

 

However, in the dataset properties the parameter name has been automatically changed to EigentFCmerEigentFCmerID (FC is the Unicode representation of the special character 'ü'):

rogerunholz_3-1635935167737.png

 

 

The Report Parameter was generated with the same name as the dataset parameter (EigentFCmerEigentFCmerID):

 

rogerunholz_4-1635935167739.png

 

 

When running the report, the following error occurs:

rogerunholz_5-1635935167742.png

 

 

Workaround: change the DAX-query manually (replacing the special character 'ü' with FC):

rogerunholz_6-1635935167750.png

 

 

The report now runs successfully:

rogerunholz_7-1635935167754.png

 

Please note, that the DAX-Query for the hidden dataset for parameter EigentFCmerEigentFCmerID also contained 'ü' instead of FC. For simplicity, the hidden dataset was removed from this example.

 

If needed we can as well provide the .pbix file which we used to reproduce the bug.

 

Many thanks for your help and regards,

Roger

1 REPLY 1
V-lianl-msft
Community Support
Community Support

Thanks for your sharing

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.