Hi, I'm trying to use the published data from the Power BI Option Set Assistant for D365, but I realized that it's not going to work as is it's supposed to unless there are unique underlying values for the option set value across the system. Unfortunately, I have multiple option sets on each entity, and all of my option set values start at the 864,000,000 value, so the values aren't matching up properly because of this. How can I extend this to get the values per my correct field? I.e., I have 2 option sets on the loans table,
new_Source
Web | 864,000,000
Print | 864,000,001
new_Type
Bank | 864,000,000
Personal | 864,000,001
I can't join the option set table with my loan table due to both fields having the same numerical value. Without going back and redoing every single option set value in my system, is there another way to get the labels linked to the right value on my Loans entity? Or is there a way to add the extra criteria of the attribute name, ie. "new_Type"? I tried following this https://www.catapulterp.com/power-bi-option-set-assistant-d365/ and it didn't work because of the values.
