Forum Discussion

tcash's avatar
tcash
Icon for Helper I rankHelper I
8 years ago
Solved

PowerBI linked to SharePoint Lists and On-Prem SQL Server do not run on Enterprise Data Gateway

I am running Personal and Enterprise Gateway version 14.16.6584.1. I can mash up SharePoint Online Folder/Documents and On-Prem SQL Server on the Enterprise. But, when I added SharePoint Online List to the same Dataset, the Enterprise Gateway option was disabled and forced me to use Personal Gateway.

 

Is the ability to combine SP Lists, SP Documents, and On-Prem SQL Server in one Dataset coming soon to Enterprise Gateway....or do I need to enable something on my end to make it happen in the current version?

 

Note, I see these other related links. One is to a Completed Idea for combining Cloud and On-Prem data sources through Enterprise Gateway:  https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources.      The other is an older post that seems somewhat related to my issue:

https://community.powerbi.com/t5/Service/PowerBI-linked-to-SharePoint-Lists-require-a-Personal-Gateway/td-p/3481

  • Anonymous's avatar
    Anonymous
    8 years ago

    tcash This is still a deficiency in the Enterprise Gateway, the link you point to is not complete, it is "Started" which bodes well to it being completed sooner rather than later.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    tcash This is still a deficiency in the Enterprise Gateway, the link you point to is not complete, it is "Started" which bodes well to it being completed sooner rather than later.