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

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
Icon for Continued Contributor rankContinued 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.

    • kevhav's avatar
      kevhav
      Icon for Continued Contributor rankContinued Contributor
      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
      • aaronsteers's avatar
        aaronsteers
        Icon for Helper I rankHelper I
        9 years ago

        I am also affected by this issue, as kevhav states:

         

        "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."

         

        Our use case is that we have a sharepoint folder with shared access where users can upload their own data and then integrate it with on-prem DW data. Without the integration in the on-prem gateway, it seems we don't have a way to automate this use case.

         

        Is there a request in the feature backlog that I can vote for? It seems OAuth should be an important part of the on-prem gateway featureset, or if not, we should not recommend users to share their files in OneDrive/SharePoint.