Hi, I am new to Power Bi. I want to connect power Bi to my Dynamics 365 Dataverse. I wanted to load an entity from my Dynamics and for that when i tried to Get Data using Dynamics 365(Dataverse), I am getting the below error:
DataSource.Error: Microsoft SQL: An error occurred while receiving the HTTP response to https://passmoregroup.crm4.dynamics.com/xrmservices/2011/organization.svc/web?SdkClientVersion=9.2.4.... This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.
RequestId: TDS;87fc0822-cc5b-4285-bbb2-2046be4c7d91;2
Time: 2022-09-06T08:55:50.9865925Z
Details:
DataSourceKind=CommonDataService
DataSourcePath=passmoregroup.crm4.dynamics.com
Message=An error occurred while receiving the HTTP response to https://passmoregroup.crm4.dynamics.com/xrmservices/2011/organization.svc/web?SdkClientVersion=9.2.4.... This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.
RequestId: TDS;87fc0822-cc5b-4285-bbb2-2046be4c7d91;2
Time: 2022-09-06T08:55:50.9865925Z
ErrorCode=-2146232060
Number=40000.
Can you please suggest what needs to be done.
Thanks,
Sharon
Class=16
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Sharon_Passmore,
To make your connection successfully, you need fulfill the following prerequisites firstly.
And there are two kinds of connectors you could use: Dataverse connector and Common Data Service(Legacy). For more details, you could refer to Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Docs.
For troubleshoot, you could have a look at this official document as well: Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Docs.
Best Regards,
Community Support Team _ Caiyun