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
Solution Sage
Solution Sage

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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors