Forum Discussion

rodrigomo's avatar
rodrigomo
Advocate II
9 years ago
Solved

How to configure On-premises Gateway to SharePoint Folder source

Hi everyone!   I tryed to configure an on-premises to SharePoint Folder source but I did not have success.   In Power BI Desktop it works very well, I could connect and read the files. However, w...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi rodrigomo，

    On-premises gateway doesn't allow you to combine online data sources and on-premises data sources. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, please vote it.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

    To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset when combining SharePoint Online data source and on-premises SQL Server data source.


    Thanks,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi rodrigomo,

Do you connect to folder placed on SharePoint Online site? If that is the case, when you want to set refresh for your dataset in Power BI Service, gateway is not required. As shown in the following screenshot, you connect directly to SharePoint Online .


However, if you connect to folder located on on-premises SharePoint, please translate the above error message into English.

 


Thanks,
Lydia Zhang

  • rodrigomo's avatar
    rodrigomo
    Advocate II
    9 years ago

    You are right!
    It's just to confirm the credentials and not is necessary to configure a gatway when just SharePoint is being used.
    Thanks for this!

     

    However, my application reads data from SharePoint and(+) SQL Server base. In this case, I have an on-premises gateway to refresh the SQL data and it's not working. Apparently, the PBI services is waiting a personal gatway, but I need an on-premises gateway. See the PBI message below.

     

    I have used on-premises gateway for SQL data for other applications and it's work very well when just SQL data were used. SharePoint source can causes some problem or conflict?

     

    Thanks!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi rodrigomo，

      On-premises gateway doesn't allow you to combine online data sources and on-premises data sources. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, please vote it.

      https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources

      To work around the issue in your scenario, you can use the personal gateway to schedule refresh for your dataset when combining SharePoint Online data source and on-premises SQL Server data source.


      Thanks,

    • nobrain01's avatar
      nobrain01
      Frequent Visitor
      8 years ago

      You don't need to include it as a data source in your On-Premis Gateway. 

      Under Gateway Connection, select "Connect directly" then under Data Source Credentials set your sharepoint online credentials using OAuth2 authentication method.

      you should be able to refresh or schedule the refresh of your dataset using this configuration. 

       

       

      • rodrigomo's avatar
        rodrigomo
        Advocate II
        8 years ago

        Hi nobrain01!

        This just works for applications that have as data source only Sahrepoint files, ok?

        In my case, I have Sharepoint and SQL sources.

        Thanks

    • nobrain01's avatar
      nobrain01
      Frequent Visitor
      8 years ago

      You don't need to include it as a data source in your On-Premis Gateway. 

      Under Gateway Connection, select "Connect directly" then under Data Source Credentials set your sharepoint online credentials using OAuth2 authentication method.

      you should be able to refresh or schedule the refresh of your dataset using this configuration. 

       

       

      • James_W_Myers's avatar
        James_W_Myers
        Frequent Visitor
        8 years ago

        Hi - I've tried to use the Connect directly (seems the only available option) and still getting the same issue.  The only authentication selection I can see is: Anonymous; Windows or Basic, so no OAuth2 selection.  I've tried all of these and none see to work.