Forum Discussion
Power bi get data from dataverse
Dear Team,
I am facing an error during loading my Dataverse DB to Power BI,
the error code is like this :
DataSource.Error: Microsoft SQL: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=174; handshake=29841;
Details:
DataSourceKind=CommonDataService
DataSourcePath=org4370cfb7.crm4.dynamics.com
Message=Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=174; handshake=29841;
ErrorCode=-2146232060
Number=-2
Class=11
any advice please?
1 Reply
Hi NJuniantera ,
There are many reasons for timeouts. It may be a network/proxy issue. Do you meet the requirements below?
Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Docs
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.
