Data Refresh Error for Cosmos DB in Power BI Desktop

[Anonymous]

Hi all,

I have an issue while refreshing the power bi data on the power bi desktop, it's taking more than a week to refresh the data for other pbix files and now it's been more 4-5 days one pbix file data is still refreshing and at last every time it's throwing the error,

my data source is Cosmos Db I'm connecting through Azure Cosmos Db v1.

and my data source cosmos db table only has data around 42,000 rows.

following error:

error: DataSource.Error: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.
Details: --cosmos db url ----

Kindly please advise for the above error, thanks in advance for your suggestions..

[Anonymous]

Hi @Anonymous ,

It seems you are experiencing a refresh issue in Power BI Desktop when connecting to Cosmos DB. The error you're encountering is: "DataSource.Error: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server."

One possible solution is to reduce the amount of data being imported, as this might help with the refresh issue.

Additionally, you can check if you are able to connect to the same server and database from Excel or SSMS. If you are not able to connect, then the issue is not isolated to Power BI and you should fix the connectivity issue at your end.

If you are able to connect, then you can try changing the server name/IP address and verifying if the database name is correct. You can also try using both Windows credentials and SQL Server user ID and password.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.