Forum Discussion
Connect Odata resource from Power BI Services
If all I use is Power BI desktop I have to keep it on in order to refresh the data. The point is that I want the data to up date on its own in the cloud and not require any onpremise connection to refresh it. I want a SaaS solution.
Now I did discover that when I upload a report created in Desktop to Online my Odata connection to that data source goes with it, and I can schedule a data refresh that way. Only today, however I discovered that my refresh didnt automatically run on its own, due to my personal gateway being offline... ok now need to figure out what that is....
Is my personal gateway my power Bi desktop?
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.