Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dataset
Power BI Report Builder (version 15.7.1740.1)
Dimension-column "Eigentümer ID" contains special character (ü) and is used as a parameter:
The query designer generates the following DAX-query (please note the special character 'ü' in the parameter @EigentümerEigentümerID):
However, in the dataset properties the parameter name has been automatically changed to EigentFCmerEigentFCmerID (FC is the Unicode representation of the special character 'ü'):
The Report Parameter was generated with the same name as the dataset parameter (EigentFCmerEigentFCmerID):
When running the report, the following error occurs:
Workaround: change the DAX-query manually (replacing the special character 'ü' with FC):
The report now runs successfully:
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
Thanks for your sharing
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
9 | |
7 | |
5 | |
4 | |
4 |