Forum Discussion
On-premises data gateway (personal mode) Key Error
- 9 years ago
Hey Atish,
Interesting timing on this, as I was able to get a workaround yesterday. In order to make the personal gateway work, I set up a new virtual machine that was on Windows Server 2012 R2 Standard. (I had to setup a new machine because the client owns the other older machine and didn't want to upgrade). The Gateway (Personal Mode) is running like a gem on this new machine, which may mean there is a problem with running it on Windows Server 2008 R2 Enterprise
What are the specs of the machine you're trying to run this on?
Update: I tried to just use the full version of the on-premises data gateway, but then when I go to the Service, it says that I must use the personal mode, and will not allow me to use the enterprise. See screen shot below:
- Anonymous9 years agoNot applicable
CFOChrisH,
What data sources are contained in your dataset? You would need to add all the data sources of your dataset under the registered enterprise gateway, then you will be able to use enterprise gateway to refresh the dataset. However, please note that if your dataset contains on-premises data sources and online data sources that use OAuth type authentication, you would need to use personal gateway to refresh the dataset.
Besides, if you create reports in Power BI Desktop, you can go to File -> Options and settings ->Data source settings to check data sources, please post a screenshot about the data sources.
Regards,
Lydia- CFOChrisH9 years agoFrequent Visitor
Hey Lydia,
Sorry for my delay in responding. I've beenable to get all of my data sources except Facebook reconnected through the Enterprise gateway. Why is the OAuth not supported with the enterprise? I can't use the personal Gateway as I continue to have the issues mentioned in the original post.
- Anonymous9 years agoNot applicable
CFOChrisH,
The team is working on the feature that add OAuth type auth in Enterprise gateway. In your scenario, you can split the Facebook data source and other dta sources into different PBIX files, then publish the PBIX files to Power BI Service. The dataset that contains only Facebook data source doesn't require gatewat to refresh.
Besides, do you install the latest version of on-premise gateway(personal mode)?
Regards,
Lydia