Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Everyone,
Solved! Go to Solution.
Hi,
Yes, there are a few options for identifying and deleting unused columns from shared datasets in Power BI.
Power BI Helper Tool: Power BI Helper is a free tool that allows you to analyze and document Power BI reports. It has a feature called "Column Usage," which can identify unused columns in a shared dataset. You can select the shared dataset and run the Column Usage feature to see which columns are not used in any reports. You can then remove those columns from the shared dataset. This tool is available for download from the Microsoft AppSource.
DAX Studio: DAX Studio is a free tool for analyzing and debugging DAX queries in Power BI. It has a "Column Usage" feature that allows you to identify which columns are not used in any measures or visuals. You can connect to the shared dataset using DAX Studio and run the Column Usage feature to see which columns are not used. You can then remove those columns from the shared dataset.
Hello @maheenshahid199,
Yes, there are a few ways to identify unused columns in shared datasets in Power BI. Here are some options:
1. VertiPaq Analyzer - https://www.sqlbi.com/tools/vertipaq-analyzer/
2. Power BI Helper - https://powerbihelper.org/
3. Power BI Cleaner Gen2 The BIccountant - https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/
Be sure to test your changes thoroughly to make sure that they do not break any existing reports or calculations.
Here is a video explaining how to delete unused columns and measures.
(4) How To Automatically Delete Unused Columns And Measures In Power BI - YouTube
Do let me know if this solved your requirement.
Cheers,
Manendra
I would also recommend using Measure Killer to do this.
Hello @maheenshahid199,
Yes, there are a few ways to identify unused columns in shared datasets in Power BI. Here are some options:
1. VertiPaq Analyzer - https://www.sqlbi.com/tools/vertipaq-analyzer/
2. Power BI Helper - https://powerbihelper.org/
3. Power BI Cleaner Gen2 The BIccountant - https://www.thebiccountant.com/2021/06/27/power-bi-cleaner-gen2-is-here/
Be sure to test your changes thoroughly to make sure that they do not break any existing reports or calculations.
Here is a video explaining how to delete unused columns and measures.
(4) How To Automatically Delete Unused Columns And Measures In Power BI - YouTube
Do let me know if this solved your requirement.
Cheers,
Manendra
Hi,
Yes, there are a few options for identifying and deleting unused columns from shared datasets in Power BI.
Power BI Helper Tool: Power BI Helper is a free tool that allows you to analyze and document Power BI reports. It has a feature called "Column Usage," which can identify unused columns in a shared dataset. You can select the shared dataset and run the Column Usage feature to see which columns are not used in any reports. You can then remove those columns from the shared dataset. This tool is available for download from the Microsoft AppSource.
DAX Studio: DAX Studio is a free tool for analyzing and debugging DAX queries in Power BI. It has a "Column Usage" feature that allows you to identify which columns are not used in any measures or visuals. You can connect to the shared dataset using DAX Studio and run the Column Usage feature to see which columns are not used. You can then remove those columns from the shared dataset.
Hi @hummingbird
I am unable to locate the "Column Usage" feature in DAX Studio as advised by you.
Could you please elaborate more on where and how should I be able to access it.
Thanks
Hi
did you find the column usage feature? I am trying to do the same/
Thanks
You need to install the tool "Measure Killer" for that.
@hummingbird DAX Studio has no such feature
Also, Power BI Helper does not work for shared datasets.
We are using analyze in Excel pretty much, is it possible to detect the measures which are used in Excel and not in Power BI?
Yes, it can do that!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |