Forum Discussion
Connect Odata resource from Power BI Services
Hi jhampson,
Power BI personal gateway is used to refresh dataset, it is different from your Power BI Desktop. You can check more details about Power BI gateway from this article:https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/.
As other post, if your dataset contains on-premises data sources, Power BI gateway is required when you refresh dataset.
Please check if Power BI personal gateway is running properly on your computer, you can check if data management gateway service is on as shown in the following screenshot.
Besides, you can use on-premises gateway to refresh your dataset. Just install on-premises gateway and configure it, then add all data sources of your dataset under the registered gateway.
Thanks,
Lydia Zhang
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.
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.
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.
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