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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Continued Contributor
Continued Contributor

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?

Brunner_BI
Continued Contributor
Continued Contributor

Yes, it can do that!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.