Forum Discussion

juliliscarmo's avatar
juliliscarmo
Helper I
6 years ago

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

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 s...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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's avatar
juliliscarmo
Helper I
6 years ago

Hi @

 

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's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.