Sharon_Passmore's avatar
Sharon_Passmore
Regular Visitor
4 years ago
Status:
Investigating

Getting Error: DataSource.Error: Microsoft SQL: An error occurred while receiving the HTTP response

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 a...
Gateways
v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago
Status changed:
New
to
Investigating

Hi Sharon_Passmore,

 

To make your connection successfully, you need fulfill the following prerequisites firstly.

  • A Power Platform environment with the following privileges:
  • To access data in a table, you must have read privileges to the table.
  • To modify a table in make.powerapps.com, you must have a security role that includes maker privileges, such as system customizer or environment maker.
  • You must have the appropriate Power BI license to build and share Power BI reports.
  • To use the Dataverse connector, the Enable TDS endpoint setting must be enabled in your environment. More information: Manage feature settings

 

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

Completed Ideas