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

I gotcha...


So this is what I did. Because I couldnt get the data labels for the Option Sets I was using from Dynamics, and when you "Enter Data" natively in Power Bi, you can't add more rows later, I created external Excel files to hold the value and label data for each of my Option Sets. That must of been why Power Bi told me I had to use a gateway.

Even the personal gateway would not refresh my data when I was using external Excel files, I had to use the native Power Bi "Enter Data" tool to make it work.

 

I do find that not being able to natively get the Option Set data from Dynamics is increadibly annoying. I am moving our organization from Salesforce to Dynamics.. and I could do that very very easily in Salesforce. Working with Dynamics has been painful in comparision, which seems counter-intuitive being that Dynamics is a Microsoft product.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jhampsonYeah that's why most of our dynamics reporting is coming out of an Azure SQL mirror of the backend. I can get option set text values from the OptionsetMetadata and GlobalOptionsetMetadata tables there. We can also set up views there that pre-process a lot of the data shaping that I formerly would have done in the Power BI query editor.

  • 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.