cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kpData
Frequent Visitor

dataset trimming

What is the less manual way to lookup table.columns (not) used by any report/visuals?

Is there a "programmatica" way to get all the table.columns <-> visual.columns associations?

 

I am given a workspace with many datasets and reports. Need to trim the tables columns by identifying columns not used by any visuals.

 

Thanks!

1 ACCEPTED SOLUTION

Hi @kpData 

There's a link on the front page of her website, you can navigate to it from there..

The BIccountant – New Generation Finance - Accounting - Controlling using Microsoft BI stack

or

https://www.thebiccountant.com

Hope this helps

Stuart

View solution in original post

3 REPLIES 3
kpData
Frequent Visitor

@Burningsuit 

First, thank you for responding! I watched Chandeep's video and like the tool. However, the link provided by you and on Chandeep's YouTube page gives a page not found error.

Any idea?

Thanks again!

Hi @kpData 

There's a link on the front page of her website, you can navigate to it from there..

The BIccountant – New Generation Finance - Accounting - Controlling using Microsoft BI stack

or

https://www.thebiccountant.com

Hope this helps

Stuart

Burningsuit
Super User
Super User

Hi @kpData 

You could try the "Power BI Cleaner Tool" from Imke Feldmann the "BIccountant".

Find it here: Power BI Cleaner Gen2 is here – The BIccountant

Hope this helps

Stuart

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Top Solution Authors
Top Kudoed Authors