Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
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.
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
Bring the only needed data rows and columns.
Provide more information.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |