5
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?
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.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
#1
André Arnaud de Cal...
293,245
Super User 2025 Season 1
#2
Martin Dráb
231,925
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
