Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Dynamics CRM Option Set Values for cases to Labels in Power BI

Posted on by 2,095

Hi all

I'm trying to map a few new option set fields that I've created in the Case (Incident) entity to Power BI. I've queried the data into Power BI and noted that all my option sets reference back to the code instead of the actual label and I'm looking for a source path to download those option set data columns so that I can merge them with the main case entity table in Power BI.

I saw this article:

community.dynamics.com/.../map-dynamics-crm-option-set-values-into-labels-in-power-bi

using the old API but when I pulled the data source, it didn't include any of the case management option set fields I've created. Can someone tell me the source path to pull that data?

Mike

*This post is locked for comments

  • Mark A Profile Picture
    Mark A 5 on at
    RE: Dynamics CRM Option Set Values for cases to Labels in Power BI

    Did you find a solution for this?  I too have the same query and have also tried the above article!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans