Feb 20 2019 10:25 PM
Hi
How can I get an xls hosted on SharePoint Online to pull data from a Analysis server cube hosted onPrem?
Looking at On-Premise Data Gateway but not sure if that will work?
Something like this maybe possible? (Orange is existing infrastructure)
Thanks in advance.
Feb 26 2019 12:50 AM
I think this might help. The Data Management Gateway can be used directly from Excel, so you might not need Azure SSAS. See scenario 2 under the PowerBI section of this article.
https://docs.microsoft.com/en-us/previous-versions//dn879362(v=technet.10)