Forum Discussion

bveerendrakumar's avatar
bveerendrakumar
New Member
9 years ago
Solved

Schedule Data Refresh Issue

Hi, I have a report that gets data from on premise DB and cloud service runs on oauth. I am able to successfully build report and publish to power bi service. Now when I am trying to schedule the r...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi bveerendrakumar,

     

    Currently, there is a limitation that OAuth is not a supported authentication scheme with the On-Premises Data Gateway. You cannot add data sources that require OAuth.

     

    To work around the issue in your scenario,  you can try using the Personal Gateway to schedule refresh for your dataset.:smileyhappy:

     

    Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi bveerendrakumar,

     

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

    If is use personal gateway will I be able to use both on premise and cloud data sources by overcoming the authentication issue?

    Yes, I think so.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi bveerendrakumar,

 

Currently, there is a limitation that OAuth is not a supported authentication scheme with the On-Premises Data Gateway. You cannot add data sources that require OAuth.

 

To work around the issue in your scenario,  you can try using the Personal Gateway to schedule refresh for your dataset.:smileyhappy:

 

Regards

bveerendrakumar's avatar
bveerendrakumar
New Member
9 years ago
Hi,

Thanks for the response. Here the point is my data source is cloud source. Why should I configure cloud data source in gateway which is meant for on premise. PBI should be using gateway only for the sources that are onpremise and for cloud sources it should go through normal flow.

Is this by design? If is use personal gateway will I be able to use both on premise and cloud data sources by overcoming the authentication issue?

Thanks,
Veerendra.
  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi bveerendrakumar,

     

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

    If is use personal gateway will I be able to use both on premise and cloud data sources by overcoming the authentication issue?

    Yes, I think so.:smileyhappy:

     

    Regards