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

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:

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

https://community.fabric.microsoft.com/t5/Desktop/Renaming-table-and-fields-in-Power-Bi-Dataset-without-causing/td-p/2446785

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.