Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
eheidari
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
prateekraina
Memorable Member
Memorable Member

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 !!!

View solution in original post

5 REPLIES 5
prateekraina
Memorable Member
Memorable Member

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 !!!

Thanks Prateekraina,

 

It's fixed.

 

Emma

Hi

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

Hi @Ntn2018,

 

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

 

Prateek Raina

Thank you prateekraina.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.