Unable to convert one or multiple M partitions into native source queries - Analysis Service Direct

[juliliscarmo]

Hi all,

I am trying to connect my database - Azure Live Connection Analysis Service - to Power Bi, but I am getting this error message Unable to convert one or multiple M partitions into native source queries.

I am wondering if you know what is my problem.

Thanks, Juli

[v-juanli-msft]

Hi @juliliscarmo 

Which connector in Power BI Desktop do you use?

Please share query in Advanced editor with me(hide the privacy information).

Best Regards
Maggie

[juliliscarmo]

Hi @v-juanli-msft

I am using Azure Analysis Service, 

Please see below the picture of my Advanced Query from VIsual Studio.

Thank you for your help,

Juli

[v-juanli-msft]

Hi @juliliscarmo 

If you use Live connection mode for the Azure Analysis Service, it doesn't support "unpivot columns" for it in Power Query.

You need transform the data in data source side.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.