Comments
Update please? Posted in 2016 and still an issue... we are using a PBI report using on prem SQL and SharePoint Online data.
Any Update on this?
Hey Admin! Whats the update on this?
what does the timeline look like for this? Tried to schedule a refresh for a report combining an on-prem SQL data source and a Salesforce data source and could not.
What is soon ?????!!!!!!!
What's the timeline on getting this capability on the Enterprise gateway at this point?
I am running Gateway version 14.16.6584.1. I can mash up SharePoint Online Folders on the Enterprise. But, I cannot mashup SharePoint Online Lists on Enterprise Gateway when I added the Lists to the same pbix Dataset. However, I *can* run the combined SharePoint Online, List, and on prem SQL Server mashups using Personal Gateway. I assume the SharePoint List mashup capability is a feature that is coming soon.
With latest Gateway version (14.16.6584.1 - 23/01/2018), I am able to refresh my hybrid model with MySQL data and SharePoint Online Excel file.
2 sources are separated (no merge, union, etc.).
'@William, yes I meant "Not Working" :)
I am curious about this... I had mashed up on prem SQL data and Excel files stored in sharepoint. No way to keep it up to date using the enterprise gateway, correct? I am testing a personal gateway today to see what will happen.
Administrator on 4/25/2023 11:33:37 PM
Was finished a while back...marking as finished https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud