Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 !!!
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.