Forum Discussion

jeppesal's avatar
jeppesal
Advocate II
9 years ago
Solved

On-premises data gateway OData OAuth2

Hi,   I have some questions regarding the on-prem gateway.   Is it correct than when you use the Gateway ALL of the models connections has to go through the gateway and if so, why? If question ...
  • dimazaid's avatar
    dimazaid
    9 years ago

    hi jeppesal,

    Thanks for taking the time to walk thru the scenario and sorry to hear your frustration, hopefully we can get this resovled and get your dataset refreshing. 
    Few corrections to the statements made below:

    - Both the personal and enterprise gateway are PRO features and cannot be used with a free account. Are you seeing anything different? 

    - You can use the enterprise gateway to run your OData data source, but the limitation is the gateway doesn't support oAuth. So you will have to either use a different auth type, or seperate the 2 data sources into 2 datasets. 

    - The reason why the online data sources have to go thru the gateway is to keep your on-prem data secure, esp when you have mashup scenarios

     

    Finally we acknowledge the auth types gap between the PBI desktop and using it in the service and we're working on addressing them soon in later releases. 

     

    Thanks,
    Dimah 

dimazaid's avatar
dimazaid
Microsoft Employee
9 years ago

hi jeppesal,

Thanks for taking the time to walk thru the scenario and sorry to hear your frustration, hopefully we can get this resovled and get your dataset refreshing. 
Few corrections to the statements made below:

- Both the personal and enterprise gateway are PRO features and cannot be used with a free account. Are you seeing anything different? 

- You can use the enterprise gateway to run your OData data source, but the limitation is the gateway doesn't support oAuth. So you will have to either use a different auth type, or seperate the 2 data sources into 2 datasets. 

- The reason why the online data sources have to go thru the gateway is to keep your on-prem data secure, esp when you have mashup scenarios

 

Finally we acknowledge the auth types gap between the PBI desktop and using it in the service and we're working on addressing them soon in later releases. 

 

Thanks,
Dimah 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This was two years ago, any progress? The reason I ask is that whenever a SharePoint source is involved, we see "Edit Credentials" and when we do, it fails even if we put Domain\UserID. We use Windows Auth and have tried a Web Conector for Excel files, Excel (which doesn't exist on the Gateway list), SP Online List, and SharePoint Lists. These are in a Mash-up with DB sources like Hana. I suspect it is using the Email address to try an login to our Internal SharePoint instead of the Domain\UserID, how can I tell?

 

So, how does separating them into separate Datasets help?

 

Jon