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,

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

So basically the sets the other users are trying to refresh are just too large for PowerBI to handle it then? So would you then say that is not the appropriate tool for handling data sets with hundreds of millions to billions of rows?

 

If so wat would you suggest as an alternative?