Forum Discussion
Power Bi schedule Refresh
Hi All,
I am using python script source and azure cosmos db source i.e Document DB in power bi report after publish the report . I applied schedule refresh
and because of python script source i am using personal gateway.
so when the data refresh then i got this error :
Last refresh failed , before the data import for finished , data source timed out. Double check whether that data source can process import query .
And because of milions of data it takes 4 to 5 hour
Please suggest me solution
Thanks
3 Replies
Anonymous , Usually there is a timeout option in the connection, you can increase that
amitchandak But this time out option connection is only available when we use SQL query and connect to SQL DB , please suggest me for Azure cosmos db
Hi Anonymous
These docs may be helpful.
Troubleshoot Azure Cosmos DB service request timeout exceptions | Microsoft Docs
Troubleshoot Azure Cosmos DB HTTP 408 or request timeout issues with the .NET SDK | Microsoft Docs
Also please note that Connecting to Azure Cosmos DB with the Power BI connector is currently supported for Azure Cosmos DB SQL API and Gremlin API accounts only. Do you use either of them?
Power BI tutorial for Azure Cosmos DB connector | Microsoft Docs
Best Regards,
Community Support Team _ Jing
