Any limit on data volume sourced from spreadsheets/db to power BI

[Anonymous]

Hi All,

Is there any limit in importing data to power BI (desktop/service) ?..We have spreadsheet whose total size goes beyond 500MB and they are imported in power BI and modelled further.

Any help is appreciated.Thanks.

Regards

Varshada

[HarishKM]

@Anonymous Hey,

There are many limitation in the dataset size of PowerBI, there is a 1 GB limit, per dataset, that is imported into Power BI. For PowerBI Service, users with a Power BI Pro license can create app workspaces, with a maximum 10 GB of data storage each. Other user will have a maximum 10 GB of data storage.

Here is a document related to this, I would suggest you referring to it: https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi

[selimovd · Accepted solution]

Hello @Anonymous ,

on Power BI Desktop your laptop is the limit. So you could also import a terabyte if your notebook would have enough resources.

In Power BI Service the file size limit is 1GB, but in compressed status. So when you save the file as PBIX it is compressed and this size cannot exeed 1GB with a free or pro account. If you have Power BI Premium or Premium per User there are higher limits.

Be aware that your data source can also have limits, like a timeout after a specific duration.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[sayaliredij]

It depends on your RAM. power bi capacity. But 500 MB should be fine

Regards,

Sayali