Audit dataset

[ROG]

Hello guys!

My dataset has reached it's limit on size, so I was wondering how can I audit the dataset to understand if there is any unnecessary data in there and remove it?

Is there a tool?

How would you do it?

My license type is PPU, and I won't upgrade to capacity due to numbers of users.

Many thanks!

[NickA01]

@ROG

Hi, 

Is the report being used already? 
If so, the best course of action here is to reach out to the users and find what they are actually using the report for. 
Additionally, a screenshot of the report ( mask your data if necessary)  would also help. 
If this is a couple of graphs then a wide data table that the business are downloading and doing excel based analysis,  then you need to check before you remove any columns.

Also , depending on your source & licensing, paginated reports may be a consideration. 

Hope this helps 

The Nick

If the post helps please give a thumbs up || If it solves your issue, please accept it as the solution to help the other members find it more quickly.

If it's the biggest heap of stinky smelly stuff then I'm sorry .

[HarishKM]

@ROG Hello,
You can refer solution mentioned in this blog by @Matt alington

You this How to find unused columns in my Power BI Data Model? - Excelerator BI


Thanks
Harish M

[Idrissshatila]

Hello @ROG ,

Download the Power BI file and open it then go to power query and try to remove the unneeded columns and you can filter out columns.

check this https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[ROG]

Thanks @Idrissshatila 

But I need to know which columns the business don't use, so I can remove it.

@amitchandak   Could you please advise?

Many thanks!

@amit