cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Power BI workspace limits

Is there a limit to the number of reports one can upload in a single workspace?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @trisabiswas,

 

Please refer to the online documentThe workspace allows only maximum of 200 datasets to be published with in it. This limit of 200 includes the combination of datasets and reports together. Also there are some workarounds.

 

- Flush out the unwanted/unused dataset from the workspace.

- Create another workspace and use it particularly for large datasets.

- You can also use the Get Data method to import local files into Power BI Service by keeping the PBIX files into OneDrive or any local folder or any other Power BI supportable data source locations.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

5 REPLIES 5
Community Support
Community Support

Hi @trisabiswas,

 

Actually that depends, as dataset will be compressed in a reasonable level when you import the data into Power BI. Users with a Power BI Pro license can create app workspaces, with a maximum 10 GB data storage each, all the contents are included  like reports, dashboards. What’s more, the limitation on the dataset size of a PBIX file is 1 GB for Pro. For Power BI Premium, you can get 100 TB of storage for each capacity you provision, all the contents are included  like reports, dashboards. What’s more You will be able to build models as large as the Power BI Premium dedicated capacity memory can hold. This means that the Power BI Premium P3 SKU will be able to support a dataset with 50 GB of data or more, and upcoming SKUs will offer capacity sizes that allow datasets with hundreds of gigabytes of data!

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

I found some links where developers said that only 200 reports are allowed to be created. e.g. Check this one: Max Report Limit PowerBI

 

Is this the case? I could not find any official documentation regarding this.

Hi @trisabiswas,

 

Please refer to the online documentThe workspace allows only maximum of 200 datasets to be published with in it. This limit of 200 includes the combination of datasets and reports together. Also there are some workarounds.

 

- Flush out the unwanted/unused dataset from the workspace.

- Create another workspace and use it particularly for large datasets.

- You can also use the Get Data method to import local files into Power BI Service by keeping the PBIX files into OneDrive or any local folder or any other Power BI supportable data source locations.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Hi @trisabiswas,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

It seems like the limit has been increased to 1000.
[Edit]: The official Microsoft documentation mentions:

  • Workspaces can contain a maximum of 1,000 datasets, or 1,000 reports per dataset.
  • A person with a Power BI Pro license can be a member of a maximum 1,000 workspaces.

https://docs.microsoft.com/en-us/power-bi/service-new-workspaces

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors