Power BI connecting to CRM via Dataverse Connector versus Database

(0) Share

Report

Posted on by cwal

I am a Power BI report developer connecting to the Dynamics CRM via Power Query using Import Mode. I have a choice of the Dataverse Connector ( CommonDataService.Database ) or SQL Server ( Sql.Database with port number 5558 )

I prefer the SQL Server connector as I can write my own SQL Query against it. The tables seem to be the same. Are there any issues using SQL Server connector over the Dataverse Connector?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Bipin D365 28,985 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The only problem which I can think of is Lookup name and optionset text value. You can still get these values by joining your table with string map and with related entity when you use direct SQL query. However you can easily get these values as part of the same table when you use Dataverse connector.

Other than this I don't think there should be any issue.

You can also find great article below which compares different ways to connect to Dataverse from Power BI.

crmchap.co.uk/evaluating-power-bi-desktop-connector-options-microsoft-dataverse-dynamics-365-customer-engagement

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No