Maximum size of .pbix file?

[Anonymous]

hi, 

I am using PBI Desktop and creating some reports with huge amount of data. 

my .pbix file which is on my local system has size 980 MB currently. do we have a limit here or can i import more data in same file.

is it possible to make .pbix file with 2 GB size. Will it work.

[Anonymous]

Hi @Anonymous,

Currently, pbix file size limit is 1GB, if you have to load large number of data which will over the limit, you can use the directquery mode to connect the database.

Reference:

Power BI Service May Update: File Size Increase to 1 GB

Use DirectQuery in Power BI Desktop

Regards,

Xiaoxin Sheng

[Anonymous]

I have 5 Million of rows and I think direct query has limitation for 1 Million of rows?? What can i do here ??

[Anonymous · Accepted solution]

Hi @Anonymous,

Sorry for slow response, the limitation number means the displayed records amount. As document said, you can add filters or summary records to cut down the display records to solve this issue.

This situation can occur with a simple chart that includes a very high cardinality column, with the aggregation option set to Don’t Summarize. The visual needs to only have columns with a cardinality below 1 million, or must have appropriate filters applied.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Everyone,

What is the maximum size for a Power BI Desktop PBIX files ?

Thank you.