Forum Discussion
New Gateway (Personal Mode) problem :(
WHAT HAPPENED?? Now Microsoft have managed to mess up the Gateway tool totally :smileymad: To combine on-prem SQL Server data with online OData (using OAuth2) I need both gateways (on-prem + ...
Hi Lydia,
Thank you for your answer.
I'm already using the new On-premises data gateway (personal mode) BUT I'm frustrated that the option to run it as a service was removed with such a short notice.
It is very hard for a customer's IT department to accept a solution that requires a personal gateway with the user logged on a pc/server somewhere and if the user is logged of, the refresh fails.
Regards
Jeppe
jeppesal,
As a workaround for the issue, you can either use a different auth type for OData, or separate the two data sources into two datasets, then use on-premises gateway to refresh the datasets.
Meanwhile, you can submit an idea about that run on-premises gateway (personal mode) as service in the Power BI ideas forum.
Regards,
Lydia