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.
Hi all,
I've recently found out how to export a power BI data model directly to tabular by following this article:
http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/
Since Power BI creates a local instance of an SSAS model you can find it and generate an XMLA script which builds the model. FANTASTIC!
Unfortunately, I am having problems with my XMLA script, some of measures include an & as I am concatenating two columns and it appears the XMLA query doesnt like this:
The error given is the syntax for 'County' is incorrect.
I have limited experience with XMLA so I was wondering if anyone could help me out with overcoming this error.
Thanks,
Will
Solved! Go to Solution.
@Anonymous
Please try to add brackets like (&) to escape. If it still doesn't work. Please use CONCATENATE() function to combine two columns in your DAX formula.
Regards,
@Anonymous
Please try to add brackets like (&) to escape. If it still doesn't work. Please use CONCATENATE() function to combine two columns in your DAX formula.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |