Is it possible to rename a table in database when connection is Direct Query?

[eheidari]

Hi everyone,

I've already created a report in power bi desktop via direct query. I would like to know if the name of table is changed in sql database, is there any way to update/modify my report or I should create another report again?

Thanks,

Emma

[prateekraina · Accepted solution]

Hi @eheidari,

No need to create another report. You can do following to rename your table in Power BI also:

1. Go to Query Editor in Power BI Desktop.
2. Click on your table and in Power Query section on the right click on Navigation.
3.  Change the item name which is your table now. It will look like below:

= Source{[Schema="dbo",Item="TableName"]}[Data]

Thanks !!!

[eheidari]

Thanks Prateekraina,

It's fixed.

Emma

[Ntn2018]

Hi

did you have to correct all the visuals using fields from that table as well?

[prateekraina]

Hi @Ntn2018,

Ideally, it should not happen. The change in query editor reflects in all the visuals after refresh.

Prateek Raina

[Ntn2018]

Thank you prateekraina.

I thought this would have been necessary, as it happens for sure if the connection is LIVE to Tabular Model AS.