There are a few different ways to get your Dynamics 365 data into Power BI. Now that the Common Data Service connector has come out of preview and is generally available, I figured it would be a good time to have a look at the different methods and how they stack up.
The different direct methods are:
- Dynamics 365 Online connector
- Common Data Service (CDS) Connector
- FetchXML (via Power Query Builder for XrmToolBox)
You can also use OData directly, but since this option doesn’t have any benefits over the other three, I am going to leave it out. The Data Export Service does have some benefits, but I will have to leave that for a different blog post.
View original post 2,494 more words