What is differenced between Tabular and PowerPivot on Sharepoint 2013?


  • I would like to build SharePoint 2013 based reporting portal with Power View as visualization tool.

    I have 2 scenarios as data source. A) SQL Server Data Mart. B) Flat Files
    I have 300-800 millions fact rows.
    I would like to refresh data atleast once in hour.

    How tabular and Power Pivot is different concerning data source?
    How tabular and Power Pivot is different concerning data refresh? (real-time requirements)
    How tabular and Power Pivot is different concerning performance?


    Saturday, June 21, 2014 1:48 PM


  • Hi keeny_I,

    According to your description, you are creating a PowerView report on SharePoint 2013, now what you want is compare which connection is better, Excel PowerPivot workbook or SQL Server Analysis Service tabular model.

    As per my understanding, there is no any difference between the Excel PowerPivot workbook connection and SSAS tabular model connection. For both Excel PowerPivot workbook and SSAS tabular model, we can use a shared data source (RSDS) connection file or a BI Semantic Model (BISM) connection to connect to it. For the data refresh, I don’t think it’s relate to which connection you used. It’s relate to the configuration of your data source. Here are some useful links for you reference.
    Create a connection to a data model for Power View
    Comparison of Direct URL, BISM, and RSDS Data Connections for a Power View Report

    Hope this helps.

    Charlie Liao

    If you have any feedback on our support, please click here.

    Charlie Liao
    TechNet Community Support

    Monday, June 23, 2014 2:25 AM