Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
maheenshahid199
Regular Visitor

Identify and delete unused columns from all reports using shared dataset

Hello Everyone, 

My boss wants to identify and delete unused columns from all the reports which are using shared datasets(which means one dataset is using in multiple reports). Is there any way or external tool which can show those unused columns in one single time ?

 

 

 

3 ACCEPTED SOLUTIONS
hummingbird
Helper II
Helper II

Hi,

 

Yes, there are a few options for identifying and deleting unused columns from shared datasets in Power BI.

  1. 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.

  2. 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.

  3. Bravo for Power BI: https://www.sqlbi.com/tools/bravo-for-power-bi/ 

View solution in original post

Sahir_Maharaj
Super User
Super User

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.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 13K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

View solution in original post

Hi @maheenshahid199 

 

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

View solution in original post

10 REPLIES 10
Brunner_BI
Super User
Super User

I would also recommend using Measure Killer to do this.

Sahir_Maharaj
Super User
Super User

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.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 13K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Hi @maheenshahid199 

 

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

hummingbird
Helper II
Helper II

Hi,

 

Yes, there are a few options for identifying and deleting unused columns from shared datasets in Power BI.

  1. 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.

  2. 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.

  3. Bravo for Power BI: https://www.sqlbi.com/tools/bravo-for-power-bi/ 

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

@EarlCarroll @kaushalb Use Power BI Helper Tool. 

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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors