Forum Discussion
Data Source offline - unable to refresh data through PowerBI service
Hi,
Thanks for your reply.
Im not sure if i have found the solution but after creating addtional space on the server (i noticed that there was limted free space), the data sources are no longer timing out and seem to be refreshing fine.
Hi. Let me check if got this right. You have a PBI dataset connected to an Azure SQL Database and other sources that require a gateway, because if you are just using Azure SQL Database you don't need a gateway.
In order to make cloud and onpremises sources work properly, you need to enable an option on the gateway
That's a start. Then regarding the message of the issue it says there is a timeout. It's not offline. The timeout can be for two reasons. One, the query is taking more than the command timeout specified by the Power Query code on the source step. If not specified it's between 10 or 15 minutes. Two, there is another timeout that can be configured at SQL Servers regarding how much time a query can take. That last might be more difficult to find, I would suggest talking with a DBA if all the things I have said before are ok.
I hope that helps,
Hi,
Thanks for your reply.
Im not sure if i have found the solution but after creating addtional space on the server (i noticed that there was limted free space), the data sources are no longer timing out and seem to be refreshing fine.
Well if the memory of the server is busy almost everyday or the disk is out of space it can response a timeout because it needs some memory to use from the server and sometimes it creates a copy of the pbix while refreshing on the disk as temporal file. If it can do it, then fails.
I hope you solution keeps working! just remember to monitor the space on the server