Forum Discussion
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?
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.
Did I answer your question ? Please mark this post as a solution.
Thanks,
Jai
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:
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.
2 Replies
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.
Did I answer your question ? Please mark this post as a solution.
Thanks,
Jai
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:
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.