Memory Error while refreshing the dataset in Power BI Service

[neetu14]

Is there any way to resolve this issue apart from increasing the capacity memory storage.

How can I optimize the data? 

[v-lionel-msft · Accepted solution]

Hi @neetu14 ,

" I have a premium capacity."

1. Check the size of the data set;

2. Check memory usage;

3. If both of the above conditions are positive, there may be a bug, please create support ticket .

Please refer to this link for specific content 

"Problem: Refresh is failing either with SQL Query Timeout or Memory Allocation Failure for the first time."

Try to update the gateway to the latest version:

https://powerbi.microsoft.com/en-us/gateway/ 

Best regards,
Lionel Chen

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

[Anonymous]

@neetu14 

You may want to take a look on the data reduction technicques 

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

[neetu14]

Thanks. I have a premium capacity. I read the article you posted and followed some steps like removing the default summarization.

Situation: I have only loaded 3 days of data by putting parameters and enabling incremental refresh and successfully publishing the report to Power BI Service. I know Power BI Service will override the parameters when it refreshes the dataset for the first time loading all the historical data and use incremental refresh afterwards.

Problem: Refresh is failing either with SQL Query Timeout or Memory Allocation Failure for the first time.

[Anonymous]

Hi @neetu14 

Hope your problem resolved.  Can you provide more details about the solution which would help others in the community and also mark the post as accepted solution.

[neetu14]

My problem is not solved yet. i have created a support ticket to get help with this issue.