Forum Discussion
Power Bi Service Refresh - timeout expiration issue
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.
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
- 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
Hi piyushj,
You are able to enter 250 minutes. Or you can directly change duration value in Advanced Editor.
Regards,
Lydia ZhangI'm having this issue in the Power BI Service (not desktop) when attempting to configure a new datasource. There are no options to manually set a timeout, and the default seems to error out after about 60 seconds.
How do we get around this?
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?