Publish large PBIX file(around 2gb) to premium workspace

[AtulKale9]

Hello folks,
In my current development there will be need of publishing my Pbix file to premium workspace(as size is above 1gb) Is there any issue(performance) while accessing and refreshing report there?

Thanks in advance!

[AtulKale9]

Basically I want to publish large pbix file over service workspace. Let me know if anyone has worked on below scenario.

[venal]

@AtulKale9 

please refer the below links for best practices to avoid the perfromance issues.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-best-practices

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

https://docs.microsoft.com/en-us/power-bi/service-dashboards-design-tips

if you find that there was perfromance issue, please monitor the premium capacity metrics to found the details.

https://docs.microsoft.com/en-us/power-bi/service-premium-what-is#capacity-nodes

[AtulKale9]

Thank you @venal for your reference links.

[v-diye-msft · Accepted solution]

Hi @AtulKale9 

If your data model is larger than can be accommodated in the Power BI Service, you might need to explore DirectQuery or Live Explore with a SQL or SSAS source, respectively.

Also, Based on @venal 's suggestion. here're other blogs about optimize performance for your reference:

https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up