Forum Discussion

54013's avatar
54013
Regular Visitor
2 years ago

Timeout Error while Refreshing Import mode dataset in power bi service

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 ...
Need Help
ibarrau's avatar
ibarrau
Super User
2 years ago

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's avatar
54013
Regular Visitor
2 years ago

Data source is Cosmosdb via import mode in power bi.

  • ibarrau's avatar
    ibarrau
    Super User
    2 years ago

    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,