Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
We are Power BI PRo users. We have a data model that suddenly surpassed the max 1GB size.
The data model has multiple tables. How can we find out which one (or several) tables are most responsible for surpassing the size limit?
Are there any diagnostic tools available in Pro to help with this? Realize there are tools in Premium but we are not Premium clients and it is a big jump in $.
Appreciate any help you can provide.
Thanks,
Dan
Solved! Go to Solution.
Thanks - found these tools to help - per your reply.
https://www.sqlbi.com/articles/data-model-size-with-vertipaq-analyzer/
Closing ticket - thanks for your help
Hi,
You can view your dataset size on Power BI Service->Setting->Manage personal storage:
Hope this helps.
Best Regards,
Giotto
Thanks @v-gizhi-msft (Giotto)
I should have been clearer in my description - I can see that value for the entire dataset/data model. But, I need to know the size of the individual tables within the dataset so I know which I need to filter down more to get below 1GB. How do I get this more granular detail?
Thanks,
Dan
Hi,
There is no such function on Power BI Service.
And i think you can download the pbix file and try to use DAX Studio to show each table's size.
Best Regards,
Giotto
Thanks - found these tools to help - per your reply.
https://www.sqlbi.com/articles/data-model-size-with-vertipaq-analyzer/
Closing ticket - thanks for your help