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 source queries.

 

I am wondering if you know what is my problem.

 

Thanks, Juli

Need Help

3 Replies

  • 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.