Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft 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,