Recently they added a new connector for PowerBI – and you may want to use it in place of your Dynamics 365 connector!
Here are some of the key benefits:
Improved performance
Data load and refresh times will be decreased. This was a big pain point with the D365 connector when working with large datasets.
Sorting the entities by custom and system entities
When you decide to bring in tables, you can see which entities are system and which are custom from the data table selector.
Friendly option set values
Options sets will show up as their friendly values. Before, you would have to build a table with the Value and Name and merge it with the entity table to get the friendly values.
Alphabetical order of column names in tables
This was one of my biggest pain points because the columns seemed to show up in no particular order using the D365 connector. With the CDS Connector, the columns will be in alphabetical order when you need to edit the queries.
