Power Bi schedule Refresh

[Anonymous]

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 

[v-jingzhang]

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 Java v4 SDK | 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

[amitchandak]

@Anonymous , Usually there is a timeout option in the connection, you can increase that

[Anonymous]

@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