Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
rnwg47
Regular Visitor

Getting Datasource Exceeded Limit while deploying PowerBI Report

I am getting the below error while deploying a Report in PowerBI. I checked the size of the dataset, the size does not exceed the 1.5 GB Limit. Can anyone please provide some suggestions?

 

{
  "error": {
    "code": "DMTS_PowerBIDataMovementUserDatasourceExceededLimit",
    "pbi.error": {
      "code": "DMTS_PowerBIDataMovementUserDatasourceExceededLimit",
      "parameters": {},
      "details": [],
      "exceptionCulprit": 1
    }
  }
3 REPLIES 3
ShubhamKapadnis
Frequent Visitor

Hi @rnwg47 , were you able to resolve this? We have ran into same issue, the application was running for a year without any issue and suddenly we have started encountering this issue.

v-yohua-msft
Community Support
Community Support

Hi, @rnwg47 

Thanks for the reply from GilbertQ , please allow me to provide addition:

Check the complexity of your dataset, even if the dataset size is less than 1.5 GB, the complexity of your data (e.g., number of columns, relationships, and calculated columns) can sometimes cause problems.
If you're using a service principal for authentication, there might be an issue with their permissions or configuration. Some users have reported that reconfiguring the service principal or using a different service principal solves this issue.
If you're using the Power BI REST API, make sure you haven't reached any API limits. Sometimes, repeated API calls in a short period of time can trigger this error.
If you're using an on-premises data gateway, check its configuration and make sure it's up to date. Sometimes, gateway issues can cause data movement errors. You can check the following link:

Troubleshoot gateways - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

GilbertQ
Super User
Super User

Hi @rnwg47 

 

The PBIX size is when it is compressed, when it is actually loaded it is 3-4x larger.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.