Power BI Desktop Business Central syncs online but not with desktop

[nbs33]

Hi,

I inherited a Power BI data model and am working on making some updates. It uses the Business Central connector and syncs fine online, but when I download the pbix file and try to refresh, the connection times out. It is the web based version of Business Central.

I get the following error after about a half hour of loading:

OLE DB or ODBC error: [DataSource.Error] Dynamics365BusinessCentral: Request failed: The underlying connection was closed: The connection was closed unexpectedly..

Any help is greatly appreciated, thanks!

[v-yiruan-msft]

Hi @nbs33 ,

Please review the content in the following links which have similar problem with you and check whether their solution can help you resolve the problem.

The request failed. The underlying connection was closed: An unexpected error occurred on a receive  (Solution: Upgrade the TLS version of your Power BI application to TLS 1.2 )

Power BI Service D365 ODATA Refhresh Timeout (Check the message 7 from @Alarik )

OData feed D365 Connection Error

Best Regards

[amitchandak]

@nbs33 , Is there any ip whitelisting is needed for that(By Dynamics365BusinessCentral)? I doubt power bi service ips are already whitelisted and your ip (desktop) do not have access