Load Option set from D365 CRM to Power BI data model | CloudFronts

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!


Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close