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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Data_Dasher
Frequent Visitor

Change data view names(data views from Azure Data Bricks)

Hi, 

Our data engineers want to rename the views that are used as datasets in many of our power BI reports, and I would like to know if this will break the report? What happens to all the measures created on these views? I know that I can update the view names using the "Transform Data" button, then navigating to source and changing the name there, but what happens to all the measures, calculated columns and relationships? Will these break?

2 ACCEPTED SOLUTIONS
Jai-Rathinavel
Super User
Super User

@Data_Dasher Unless you change the name of the table in the dataset none of the reports will break. But once you change the view name the power query will break if you see below the one highlighted in yellow is the Table name and one in green is the view name.

So once the view names are changed in the db just head over to PBIX File of Dataset -> Select a Query -> Transform data -> Then change the old view name with your new view name. Once you fix this on query level none of your reports which is dependent on this dataset will not break.

 

JaiRathinavel_0-1737440997272.png

 

Did I answer your question ? Please mark this post as a solution.

 

Thanks,

Jai




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

v-tsaipranay
Community Support
Community Support

Hello @Data_Dasher ,

Thanks for reaching out to the Microsoft fabric community forum.

 

The answer provided by @Jai-Rathinavel  was indeed correct. Additionally, I am including some more points to make it easier for you.

  • When renaming tables/views frequently or working across different environments (dev, test, prod), use query parameters for easy updates from a single location.
  • Implement a consistent naming convention for views, tables, and queries to reduce confusion and minimize disruptions.
  • Utilize Power BI’s Advanced Editor to rename views directly within the M code. This approach is particularly effective when managing numerous transformations associated with a specific view.
  • To do this, go to Transform Data → Advanced Editor and here, you can manually adjust the view name within the M code to reflect the new database structure.

I am also including the similar threads which already sorted, so kindly look into it to get better understanding:

https://community.fabric.microsoft.com/t5/Desktop/Which-is-the-best-way-to-rename-columns-in-the-dat...

https://community.fabric.microsoft.com/t5/Desktop/Renaming-table-and-fields-in-Power-Bi-Dataset-with...

 

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

 

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

 

Thank you. 

View solution in original post

2 REPLIES 2
v-tsaipranay
Community Support
Community Support

Hello @Data_Dasher ,

Thanks for reaching out to the Microsoft fabric community forum.

 

The answer provided by @Jai-Rathinavel  was indeed correct. Additionally, I am including some more points to make it easier for you.

  • When renaming tables/views frequently or working across different environments (dev, test, prod), use query parameters for easy updates from a single location.
  • Implement a consistent naming convention for views, tables, and queries to reduce confusion and minimize disruptions.
  • Utilize Power BI’s Advanced Editor to rename views directly within the M code. This approach is particularly effective when managing numerous transformations associated with a specific view.
  • To do this, go to Transform Data → Advanced Editor and here, you can manually adjust the view name within the M code to reflect the new database structure.

I am also including the similar threads which already sorted, so kindly look into it to get better understanding:

https://community.fabric.microsoft.com/t5/Desktop/Which-is-the-best-way-to-rename-columns-in-the-dat...

https://community.fabric.microsoft.com/t5/Desktop/Renaming-table-and-fields-in-Power-Bi-Dataset-with...

 

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

 

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

 

Thank you. 

Jai-Rathinavel
Super User
Super User

@Data_Dasher Unless you change the name of the table in the dataset none of the reports will break. But once you change the view name the power query will break if you see below the one highlighted in yellow is the Table name and one in green is the view name.

So once the view names are changed in the db just head over to PBIX File of Dataset -> Select a Query -> Transform data -> Then change the old view name with your new view name. Once you fix this on query level none of your reports which is dependent on this dataset will not break.

 

JaiRathinavel_0-1737440997272.png

 

Did I answer your question ? Please mark this post as a solution.

 

Thanks,

Jai




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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