Export PBI Model to Tabular

[Anonymous]

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

[v-sihou-msft · Accepted 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,