Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to Solution.
@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
Proud to be a Super User! | |
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.
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.
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.
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.
@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
Proud to be a Super User! | |
User | Count |
---|---|
47 | |
27 | |
21 | |
19 | |
18 |
User | Count |
---|---|
54 | |
47 | |
22 | |
22 | |
20 |