Forum Discussion

FS's avatar
FS
Frequent Visitor
9 years ago
Solved

Unable to schedule refresh with sharepoint and database

First off, sorry if this has been already asked/answered.   I am having trouble scheduling a refresh of one file with two data sources - one is a file on SharePoint, the other is a database. Ive g...
Need Help
  • kevhav's avatar
    kevhav
    9 years ago

    I heard back from Microsoft that...

     

    • Currently, the On-Premises Gateway does not support OAuth (a requirement for SharePoint Online connectivity); so if you have a dataset that has both SharePoint Online and on-premise data sources, that dataset cannot be refreshed using an On-Premises Gateway.

    • As mentioned here, you can use a Personal Gateway to set up a scheduled refresh of a dataset that has both SharePoint Online and on-premise data sources. This is what they recommended.

    • Microsoft is investigating the possibility of a change to allow OAuth with the On-Premises Gateway, but have have no timelines for it.

    • They recommended that I continue to to use the On-Premises Gateway for datasets where it works, but use the Personal Gateway as a "workaround" for my one dataset that has both SharePoint Online and on-premise data sources
FS's avatar
FS
Frequent Visitor
9 years ago

Greg_Deckler

The database is on-premises, data gateway is set up and working - already used to refresh few reports.

I have no problems scheduling a refresh when using only sharepoint file/only database as source, but im struggling to schedule a refresh when using both in the same report.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi FS,

 

According to your description, it seems that you are connecting to SharePoint Online Excel and on-premise database in the same report, right?

 

Based on my test, as SharePoint Online doesn't require gateway while on-premise database requires, and those two data sources requires different kind of credentials, you need to install personal gateway to connect to on-premise database and enter credential for SharePoint Online use oAuth2 authentication. See:

 

 

 

Reference:

Power BI Gateway - Personal

 

Best Regards,
Qiuyun Yu

  • FS's avatar
    FS
    Frequent Visitor
    9 years ago

    Thanks v-qiuyu-msft, I tried installing personal gateway and had no problems with setting up scheduled refresh.

     

    But I would like to utilize the on-premises (Enterprise) gateway i have been using for everything else until now for this task as well - is it even possible?

    • kevhav's avatar
      kevhav
      Continued Contributor
      9 years ago

      I have this same issue.

       

      I have a dataset with some data source files in SharePoint Online, and some on-premise data sources.

       

      I have an "On-Premises Data Gateway" that works great with my on-premise data sources.

       

      But in the Power BI service, I can't set up scheduled refresh of my dataset.

       

      So do I have to also use a "Personal Gateway" for cases like these? Isn't there some way I can use the new "On-Premises Gateway" I already have set up?

      • FS's avatar
        FS
        Frequent Visitor
        9 years ago

        kevhav, yes, same issue, thanks for wording it a bit better.

         

        I have set up a Personal Gateway for now, still hoping to make the "On-Premises Gateway" work though.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi FS,

       

      As mentioned in my original post, in your scenario, as the dataset contains two data sources, on-premises data source and SharePoint Online file, it's not supported to use on-premise gateway to build connection. Only personal gateway is available now for us to setup schedule refresh.

       

      Best Regards,
      Qiuyun Yu