Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I am using a sample superstore dataset to experiment with the cleaner tool from the powerbi sidetools(an external tool). The intent behind this is to find a more handy solution for finding/removing unused columns from my model. But using it causes an error while calculating dax formulas for column usage and generates a new blank report. I have allowed privacy access from the currentfile settings but its still the same. I have attached an image of the tool and the error it generates.
Is there anything I am missing or is this tool still in the process of development? Also is using external tool like powerbi cleaner safe in terms of data privacy?
Any help would be appreciated. Thanks!
Hi @asad_brohi ,
I am sorry to hear that. This shouldn't happen.
Have you tried to refresh multiple times?
I've seen it that a refresh after these error-messages pop up solved the issue.
Otherwise I don't have any more ideas, unfortunately. It is working fine for me.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @ImkeF ,
Just making sure that it works fine with you inside the Power BI Sidetools, is that correct? Because for me power bi cleaner works fine when used alone, but not inside the Power BI Sidetools (external tool).
Much thanks.
Hi there,
you have to disable privacy levels:
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @ImkeF , thanks for the response, I did change the privacy level to ignore but unfortunately its still displaying the same error that I shared before.
If anyone has ever used powerbi cleaner using this external tool please do help!
Let us check with Imke
@ImkeF , Please help with this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |