The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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