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
yaniv-amar
New Member

Is it possible to rename tables in Live Connection mode?

Hi,

 

When I rename a table in my tabular model and clicking Refresh in Power BI Desktop, the visual can't find the table and shows an error. Is there a way to update the .pbit to match the updated model?

7 REPLIES 7
a-b
Regular Visitor

I did it with this ugly hack.
1) Rename the .pbix file to .zip
2) Unzip it
3) Open the \DiagramLayout file with Notepad++ and replace old table name with new table name. Do the same with the Report\Layout file
4) Zip the folder back and rename to .pbix
5) Try to open the file. If you got message that the file is corrupted, try to open it on another machine. It sould work. This unexplained behavior described here https://community.powerbi.com/t5/Desktop/Programmatically-set-data-colors-by-unzipping-pbix-and-modi...

Anonymous
Not applicable

When you say the "Report\Layout file". Are you referring to the Dataset file, or do you need to .pbix Report file to a .zip and change the \DiagramLayout naming there? (just trying to work out if it needs to be changed in two files, or just the Dataset converted file). Any help greatly appreciated 👍

lachicazul
Frequent Visitor

Did you find a way?

 

Same issue here 😐

yaniv-amar
New Member

Hello,

 

This is still an issue. Any help would be appreciated

v-chuncz-msft
Community Support
Community Support

@yaniv-amar,

 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-rename-a-table-in-database-when-connectio...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Well, seriously: in case of Live Connections (to Power BI datasets/AAS/Tabular),

is it not possible to rename a table (data model) without breaking all the visuals referring to it???

Thanks @v-chuncz-msft, but it refers to Direct Query mode and my .pbit is in Live Connection mode where the Query Editor is not available (Edit Queries button is grayed out)

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.