none
SQL Server 2012 BISM to Excel PowerPivot transfer (Online to Offline)

回答

  • Hi Stony,

    A BI semantic model connection (.bism) is a portable connection that connects Excel or Power View reports to an Analysis Services tabular model database on a network server or a SharePoint farm. Could you please describe more detail about "PowerPivot Offline Version"?

    A BI semantic model connection points to tabular model data. There are two sources for this data:

    • A tabular model database running on a standalone Analysis Services instance in tabular server mode. A deployment of a standalone Analysis Services instance is external to the farm. Accessing data sources off the farm requires additional permissions, which you can read about in this topic: Create a BI Semantic Model Connection to a Tabular Model Database.

    • PowerPivot workbooks saved to SharePoint. Embedded PowerPivot databases inside Excel workbooks are equivalent to tabular model databases that run on a standalone Analysis Services tabular mode server. If you already use PowerPivot for Excel and PowerPivot for SharePoint, you can define a BI semantic model connection that points to PowerPivot workbooks in a SharePoint library and build Power View reports using existing PowerPivot data.  You can use workbooks created in either SQL Server 2008 R2 or SQL Server 2012 versions of PowerPivot for Excel.

    Regards,


    Elvis Long
    TechNet Community Support

    2012年12月25日 6:38

すべての返信

  • Hi Stony,

    A BI semantic model connection (.bism) is a portable connection that connects Excel or Power View reports to an Analysis Services tabular model database on a network server or a SharePoint farm. Could you please describe more detail about "PowerPivot Offline Version"?

    A BI semantic model connection points to tabular model data. There are two sources for this data:

    • A tabular model database running on a standalone Analysis Services instance in tabular server mode. A deployment of a standalone Analysis Services instance is external to the farm. Accessing data sources off the farm requires additional permissions, which you can read about in this topic: Create a BI Semantic Model Connection to a Tabular Model Database.

    • PowerPivot workbooks saved to SharePoint. Embedded PowerPivot databases inside Excel workbooks are equivalent to tabular model databases that run on a standalone Analysis Services tabular mode server. If you already use PowerPivot for Excel and PowerPivot for SharePoint, you can define a BI semantic model connection that points to PowerPivot workbooks in a SharePoint library and build Power View reports using existing PowerPivot data.  You can use workbooks created in either SQL Server 2008 R2 or SQL Server 2012 versions of PowerPivot for Excel.

    Regards,


    Elvis Long
    TechNet Community Support

    2012年12月25日 6:38
  • We have a model that runs on a server. Now we have some users who are not in the office (Seller) and no possibility to connect with the server across the internet. My question now. Is there a way to load the data from the Server Model into a Execl PowerPivot model.

    2013年1月2日 19:19
  • I am also looking the same kind of solution.

    Any help from any one?

    Thanks,


    Liyasker Samraj K

    2014年5月15日 5:47