data refresh exceeded limit for a single table

[oakfootballclub]

user want to see historical detail data, so the amount could be big, but the total size of pbix file is just nearly 400MB,

when I refresh data on service, the error comes like this,

how can I solve this problem?

[Idrissshatila · Accepted solution]

Hello @oakfootballclub ,

The issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

• As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently. there is limit. Apply data-point limits and strategies by visual type 

and you can follow the tips to optimize your report：

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.

3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )

This is the related document, you can view this content:

The “Visual Has Exceeded The Available Resources” Error In Power BI

Visual has exceeded the available resources - Table Visual

Error: Resource Governing - Microsoft Power BI Community

resources exceeded - Microsoft Power BI Community

• only Premium capacity can increase the per-query memory limit, you can refer to these articles if you need:  What is Power BI Premium?  How to purchase Power BI Premium,

[oakfootballclub]

Thanks. what is maximum size for a pbix file to be published into service when using a single data table for pro license workspace and user?

[Idrissshatila]

@oakfootballclub ,

for pro license is 1gb for premium it's 10gb.

[oakfootballclub]

alternatively, if I do not refresh historical data everytime, just add the current data to the table, is there any solution or demo for postgre sql? Thanks.

[Idrissshatila]

@oakfootballclub ,

check incremental refresh https://youtu.be/Kui_1G6kQIQ?si=uzFAGN1-wPkK1SNu