Load Option set from D365 CRM to Power BI data model


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!

Share Story :