Forum Discussion

WishAskedSooner's avatar
WishAskedSooner
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

SQL Server Column Name Change Error

Hi Experts!   I am inexperiencing a bizarre error. A column name was changed in SQL Server. I am connecting to the table in PQ via the following:   Sql.Database("xx.x.x.xxx", "MyDB", [Query="SEL...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,

    Thanks for Greg_Deckler 's concern about the problem and i want to offer some more informaiton for user to refer to.

    hello WishAskedSooner , based on your description, you can click the refresh button in power query after changing the column name in data source.

    And if you need to recreate the connector, you need to clear the data source permission data source serttings in power bi , then reconnect it.

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

WishAskedSooner's avatar
WishAskedSooner
Icon for Continued Contributor rankContinued Contributor
1 year ago

As you guessed, changing a column name in SQL Server is not a trivial exercise. It involves taking down all your keys, dropping the table, and re-creating it from scratch if doing it manually, or using a tool like SSDT. Why do you ask?