Forum Discussion

neetu14's avatar
neetu14
Microsoft Employee
6 years ago
Solved

Memory Error while refreshing the dataset in Power BI Service

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

 

How can I optimize the data? 

 

Need Help

5 Replies

    • neetu14's avatar
      neetu14
      Microsoft Employee
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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.