Forum Discussion

jhampson's avatar
jhampson
Frequent Visitor
9 years ago

Connect Odata resource from Power BI Services

Is there an app that will allow me to connect to an oData resource via Power BI services?  I know I can do it via the Power Bi Desktop, but what about Power Bi online services?   thanks   Jeff
Need Help
jhampson's avatar
jhampson
Frequent Visitor
9 years ago

It just seems like a lot of extra effort to manage, even if a PaaS enviroment, just to be able to see the labels of your Option Set. What the heck I am I going to do with the values of the Option Set?

At least if there was another entity in Dynamics that I could create a realtionship from that would map my Option Set Value to my Option Set Label.. that would be ok.. but to have to build an infrastructure just to map something seems ridiculous.

  • jhampson's avatar
    jhampson
    Frequent Visitor
    9 years ago

    Thanks Lydia... this looks like an adventure.. I'll try it.

    Seems like an aweful large effort just to see an OptionSet Label.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.