Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have some fields that are showing in personalized visuals, when published to the service, that represent measures that have previously been created in desktop, but then deleted. They are showing with an exclamation warning when you open the personalization. Does anybody know why these are appearing and how to remove them?
Hey @Anonymous , I found your topic, and noticed it did not have a solution, but I believe I found it.
First, why does this happen? Well for me this happened with measures that I created in the report file, after which I created a measure with an identical name in the dataset file (I use a powerBI file als my dataset, and another as my report).
This basically causes a duplicate measure to exist once you refresh your report file. For some reason, you cannot then delete this measure (this seems like a bug) and it will show up in any perspective that you create. Now you probably went a step further, and deleted the actual table from the model in your dataset file. This causes the whole table to disappear in both your report and dataset file. However, under water the report file wasn't able to remove the formerly duplicate measure from the report file, so it still exists, even though you cannot see it anywhere.
So what is the solution?
1. You will need to recreate a table (you can just use "enter data"for this) with the exact same name as your deleted table, in your dataset file.
2. You need to then upload that to powerbi, and refresh your report file so it now has that table in there too.
3. And what do you know, it also shows that invisible measure! You can now delete that measure, save your report file.
4. Then go back to your dataset file, and delete the table. You have now successfully removed the measure from the report file!
For measures that are duplicated, you should:
1. rename the measure in your dataset file temporarily.
2. Publish the dataset to the cloud.
3. Refresh your report file. You will see the warning symbol disappear.
4. Delete the measure from your report file, save
5. rename the measure in your dataset file back to the original, save.
Now it's fixed!
Hi @Anonymous ,
Has you tried as selimovd said?Or base-pbix file could not find the fields in visual?pls provide more details.
Best Regards
Lucien
Hey @Anonymous ,
you can delete the non existing measures with the X-symbol next to the none existing measure in the list of fields:
Then the visual should be displayed again without any errors.
What you are describing requires deleting these fields in desktop, but they are not appearing in the pbix at all. They are also showing in folders that do not apper in the pbix. I believe they are measures that have been created at some point, but then deleted. But they are still appearing in the personalization in the service.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
31 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
55 | |
38 | |
27 | |
24 | |
21 |