Timeout Error while Refreshing Import mode dataset in power bi service

[54013]

Can someone help to resolve timeout error issue while refreshing the power bi report.

I am able to refresh the power bi file in desktop but when its refreshed-on power bi service. Its showing below error.

[ibarrau]

Hi. What is your data source? By default there are sources with a timeout around 10 minutes. So if it takes more than that it sends the timeout. Power Bi Desktop doesn't have it. You can extend the timeout at Power Query editor. When connecting the source at the first step it usually has an "Advance Setting" at UI to change it or you can write the commandTimeout parameter depending on the code of the source. For example: sql server https://learn.microsoft.com/en-us/powerquery-m/sql-database

I hope that helps,

[54013]

Data source is Cosmosdb via import mode in power bi.

[ibarrau]

Are you using the Cosmos DB Beta connector or another?

You can check the doc of the connector to read solutions. For example, the cosmos db conector doesn't have a parameter to increase the timeout, but it specifies that it can add a parameter to retry the connection if a timeout is triggered.

https://learn.microsoft.com/en-us/power-query/connectors/azure-cosmos-db-v2

If you are using another connector like ODBC, check what odbc can offer for power query.

I hope that helps,