Forum Discussion
Export PBI Model to Tabular
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
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,
1 Reply
- v-sihou-msft
Microsoft Employee
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,