Forum Discussion
Connect Odata resource from Power BI Services
Hi jhampson,
Please check the following articles about adding option set in Power BI.
https://technet.microsoft.com/en-us/library/mt490470.aspx?f=255&MSPPError=-2147217396
http://crmtipoftheday.com/2016/07/14/optionsets-in-power-bi/
Thanks,
Lydia Zhang
Thanks Lydia... this looks like an adventure.. I'll try it.
Seems like an aweful large effort just to see an OptionSet Label.
- Anonymous9 years agoNot applicable
Anonymousooohhh I did not know you could pass FetchXML through Power BI queries. That changes things quite a bit.
jhampsonit is a bit, but I think you can just steal FetchXML from your Advanced Find editor in CRM and slightly modify it to fit this, rather than writing everything from scratch. I expect that for most things you'd want to query in BI there is already an existing list view that is at least close to the same query.