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 

Dave0145's avatar
Dave0145
Frequent Visitor
8 years ago

Dimah,

 

this reply is by way of a vote up to get this issue resolved. We also have mashups between on premise SQL datasets and Sharepoint online lists (accessed via OData) and the mismatch between PBIDesktop authorisation versus PBI portal authorisation is a source of much frustration.

 

David

  • bwhitlocksaxco's avatar
    bwhitlocksaxco
    Frequent Visitor
    7 years ago

    Is this going to be fixed soon. I cant do on premise gateway to odata due to organizational login and Azure data due to mashup. Please Fix ASAP unless Im missing something.