Solved: Reduce size

manideep547 · ‎02-25-2020

Hi All,

can anyone suggest me how to reduce my dataset? My .pbix is nearly 1 GB and I am using SQL server, import mode.

Thanks&Regards,
MANI DEEP.

v-eachen-msft · ‎02-25-2020

Hi @manideep547 ,

You could create a view in your sql server based on useful columns. If your file size is still big, you could try direct query mode. it will not save your data in pbix file.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

colivier · ‎11-07-2020

Hi @manideep547

Identifying unused columns can be a lot of work. I created PBI Spy to to make it a lot easier to do this.

In minutes it can show you which columns, hierarchies and measures can be safely removed.

Give it a try at www.pbispy.com

Feel free to contact me if you need assistance.

v-eachen-msft · ‎02-25-2020

Hi @manideep547 ,

You could create a view in your sql server based on useful columns. If your file size is still big, you could try direct query mode. it will not save your data in pbix file.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

santiagomur · ‎02-25-2020

Check this video.

https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...

Gordonlilj · ‎02-25-2020

Hi,

You could check out the blogs below

Power BI Performance Tips and Techniques

Data reduction techniques for Import modeling

2 ways to reduce your Power BI dataset size and speed up refresh

amitchandak · ‎02-25-2020

Bring the only needed data rows and columns.

Provide more information.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube