Forum Discussion

lunm3301's avatar
lunm3301
New Member
5 years ago
Solved

How to rename a table with a Direct Query connection

Hello, 

 

My organization forces us to use a Direct Query connection to a datawarehouse. When I try to rename a table that I've created, I get a message that says "Unable to convert an M query in table '...' into a native source query."

 

Can someone please help me?

 

Thank you in advance.

Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi lunm3301 ,

    Just double click the table and rename it in power query, close and apply it, it should work.

     

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

3 Replies

    • lunm3301's avatar
      lunm3301
      New Member
      5 years ago

      I tried to change the table's name both in the visual layer and in Power Query.

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi lunm3301 ,

        Just double click the table and rename it in power query, close and apply it, it should work.

         

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