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,

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,

    • alle_francisco's avatar
      alle_francisco
      New Member
      6 years ago

      Worked like a charm, thank you.

       

  • rodrigomo's avatar
    rodrigomo
    Advocate II
    9 years ago

    Uhmmm.. interesting!

    Well, I will review the data source solution for my appliation.

    Thanks Lydia

    Best!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I have not succeeded in setting up personal data gateway as a workaround.

    Now errors on set up, but on refresh frows the following: 

    "

    Something went wrong
     
    Cannot connect to the mashup data source. See error details for more information.
    Please try again later or contact support. If you contact support, please provide these details.

     

    Underlying error code-2147467259
    Underlying error messageWe're sorry, an error occurred during evaluation.
    DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
    Cluster URIWABI-WEST-EUROPE-redirect.analysis.windows.net
    Activity ID49c46a9b-d936-446a-8a24-dfc0a148008e
    Request ID08ebe341-f745-4db6-a715-e502cb408008
    Time2017-09-07 09:42:53Z

     "

     

    Any ideas what to do?