Importing Excel fileo on sharepoint to SSAS tabular Model ? RRS feed

  • Question

  • HI ,

    I am new to SSAS tabular model, I want to create a cube from three excel files which are on SharePoint and few table from SQL DWH, I can import tables from DWH but have no idea which source to use in order to import excel files (which are on sharePoint) in the tabular model ?

    Please Help[

    Friday, May 26, 2017 9:19 PM

All replies

  • Hi Kosambi2212,

    Thanks for your question.

    To import Excel files on SharePoint to SSAS tabular model,please refer to a step by step blog below:
    Importing SharePoint List Data into SQL Analysis Services

    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Monday, May 29, 2017 4:08 AM
  • HI Wilson yuan,

    I followed the steps which were mentioned in the link that you provided but am still facing difficulties in connecting, am getting the following error,  can please guide me through this, as I cannot move ahead of my task without importing the data from the SharePoint List into the tabular model.

    Error Message:

    The remote server returned an error: (403) Forbidden.

    Monday, June 12, 2017 2:27 PM