How to connect with Excel Sheet in SharePoint Online to an on premise Cube? RRS feed

  • Question

  • Hi,

    i have the following scenario:

    I have an on premise SSAS Cube and an Excel Sheet which connect to this Cube and the user is able to filter and work with the data. Now the Excel Sheet should be placed in SharePoint Online and the user should be still able to connect to the on premise Cube through Excel Services for refreshing the data etc.

    Is this possible and if yes, which options do i have?

    best regards


    Best regards BOG

    • Edited by BOG's Lab Wednesday, September 27, 2017 10:59 AM
    Wednesday, September 27, 2017 10:58 AM

All replies

  • Hi Bog,

    Per my knowledge, it is impossible.

    Office 365 prohibits data refresh against external data sources, including Analysis Services solutions that run on servers in a network. If your requirements include refreshable data, choose SharePoint or use a network file share instead.

    Best regards,

    Linda Zhang

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Friday, September 29, 2017 6:07 AM