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

amitchandak's avatar
amitchandak
Super User
5 years ago

lunm3301 , Try to rename it in the visual layer. Where are you trying to rename it, in the power query?

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