Question

You are building a Power BI report for a sales team that stores its CRM data in Microsoft Dataverse. The team requires that report data refresh on a schedule and that queries perform efficiently against many related tables. You want to use the most appropriate connectivity option in Power BI Desktop. Which approach should you use to connect to the data?

Accepted Answer

Use the built-in Dataverse connector in Get Data and select the required tables.

Answer

Use the Web connector and point it at the Dataverse OData feed URL manually.

Answer

Export each Dataverse table to a CSV file and import the files with the Folder connector.

Answer

Use the SQL Server connector pointing at the on-premises data gateway.