Load Option set from D365 CRM to Power BI data model
Steps:
Open Xrm Toolbox and add Tool “PowerBI option-Set Assistant”
Open the tool and Click on load entities, it will load all the entities.
Select the entity and field name from which we want to retrieve data, click on “Create records for selected option sets”. It will prompt that it will create new entity, click on Yes and proceed.it will create a new entity for option set.
Now go to power bi and create connection using OData feed.
Now we can see,”gap_powerbioptionsetrefs” entity created and we can load this into power bi model.
Hope this helps!
Related posts:
How to Extend Dynamics 365 CRM Using Side Panes: A Practical Implementation for a US-Based Kitchen A...
D365 CRM - Generating Emails using JavaScript via user actions for US based Azure & AI services ...
How a Multi-Country Infrastructure Group Evaluated One vs Two Production Environments in Dynamics 36...
