dataset trimming

[kpData]

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!

[kpData]

@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!

[Burningsuit · 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

[Burningsuit]

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