Forum Discussion

piyushj's avatar
piyushj
Frequent Visitor
9 years ago

Power Bi Service Refresh - timeout expiration issue

Hi PBI Team,   We are facing an issue in power bi service as well as in desktop app. We have huge amount of data available in tables (>10GB). We are importing data using SQL Server database. Previo...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi piyushj,

Firstly, based on this blog, in Power BI Service, refreshing the dataset will give an error message letting you know your dataset is too large, and it will fail to refresh until you filter the data model back down under 1 GB.

Secondly, optimize your data model following the guide in this blog in Power BI Desktop, the blog also applies to Power BI Desktop though it is about PowerPivot.

And specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can  refresh successfully in Power BI Desktop.

1. Click on the arrow for "Edit Queries" in your current Power BI Desktop file, select "Data Source Settings” in the dropdown.
2. Click on "Change Source..." in the Data source settings pop-up window.
3. Click on Advanced Options in the pop-up window, enter 60 minutes in the "Command timeout in minutes (optional)" textbox, then click OK.

Thanks,
Lydia Zhang

  • piyushj's avatar
    piyushj
    Frequent Visitor
    9 years ago

    Hi Anonymous

     

    I'm using power bi pro trial version. I have huge amount of data more than 2 million rows. I have also used direct query option but still direct query is not enough for us. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi piyushj,

      The 1GB limitation of data model during refresh in Power BI Service also applies to users who have pro license, this limitation is different from the 10GB data capacity limit for pro users. The 1GB limitation is for the data model within each PBIX file you upload to Power BI Service.

      You can rename your current PBIX file to .zip and check the size of the data model within it. For more details, please review this blog. If the data model size is too large to refresh in Power BI Service, please break up your dataset into smaller datasets and refresh them in Power BI Service.

      Besides, have you specified value in "Command timeout in minutes" in Power BI Desktop?

      Thanks,
      Lydia Zhang

      • piyushj's avatar
        piyushj
        Frequent Visitor
        9 years ago
        Yes , I specified command time out to 90 mins but after that it throws the same error. Is there any limitations if I give 250 mins duration in command time out