Power BI Size Limitation / Maximum

[Anonymous]

Hi,

I've been working in Power BI since January and I've created a good amount of dashboards.

Just today I started building what I thought would be a rather large dashboard, populated by what would be a 310MB csv excel sheet and another 59MB excel sheet.  I had also planned on building a calendar table and multiple slicers.

However, I'm afraid the 310MD csv is simply too large for Power BI to handle.  Over 420,000 and 70 columns.

My question is, is this really exceeding the limitations of Power BI or is it simply my connection timing out due to me having to work remotely from home?

When I go to save it errors out stating as such.  Yet the folder where I went to save it has a file there of 25,079KB.  When I go to open it, it fails to open so I'm unsure of the real issue.

Any help or clarification would be helpful.

[Icey · Accepted solution]

Hi @Anonymous ,

In Power BI Desktop, there is no data volume limitation for a load.

However, when you want to publish a .pbix file to Power BI Service, the dataset of a single .pbix file must be smaller than 1 GB. Power BI Premium supports uploads of Power BI Desktop (.pbix) files that are up to 10 GB in size. Once uploaded, a dataset can be refreshed to up to 12 GB in size. To use a large dataset, publish it to a workspace that is assigned to Premium capacity.

Other limitations:

• Distinct values in a column - When caching data in a Power BI dataset (sometimes called 'Import' mode), there is a 1,999,999,997 limit on the number of distinct values that can be stored in a column.

• Row limit - When using DirectQuery, Power BI imposes a limit on the query results that are sent to your underlying data source. If the query sent to the data source returns more than one million rows, you see an error and the query fails. Your underlying data can still contain more than one million rows. You're unlikely to run into this limit as most reports aggregate the data into smaller sets of results.

• Column limit - The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop. Power BI tracks the number of columns and tables in the dataset in this way, which means the maximum number of columns is 16,000 minus one for each table in the dataset.

Reference:

File size limit increase to 1 GB

Power BI Premium support for large datasets

Considerations and limitations

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous - In a word, no none of that seems like it would even come close to hitting any kind of limitation in Power BI. I've worked with CSV files with millions of records. Difficult to say exactly what your issue is, but it is not likely to be any kind of Power BI limitation of which I am aware. 310 MB files? That's laughably small all things considered.