locked
Excel 2013 Power View - Do not work without active connection with underlying data source RRS feed

  • Question

  • Hi,

    As mentioned on few following forums that PowerPivot creates an SSAS DB and holds actual data fetched from source into same excel file in a very Compressed VertiPaq DB. 

    Understanding PowerPivot and Power View in Microsoft Excel 2013

    PowerPivot data is in the worksheet

    My PowerView sheet in relying on Power Pivot model but after re-opening excel file, PowerView do not show data unless the underlying data source DB (e.g. SQL Server) is accessible as well.

    So What is the reason of this behaviour, if data is already fetched and can be viewed in PowerPivot? How PowerPivot works?

    Does PowerPivot really holds whole data or just sample of fetched data only? Or PowerPivot is like a traditional SSAS separate DB created with new style?

    Many thanks and kind regards.


    For quick review of new features, try virtual labs: http://msdn.microsoft.com/en-us/aa570323

    Monday, June 2, 2014 2:51 PM

Answers

  • You are right that Power Pivot models are effectively an encapsulated/embedded SSAS Tabular database. Any data the you load into it is stored in it's entirety in the xVelocity storage engine. 

    Power View on the other hand gets the data in bite-sized chunks based on what you are viewing/interacting with. As you interact with the Power View reports/dashboards, DAX queries are being generated on the fly and sent to the Power Pivot model. As a result, Power View always needs to refresh manually or automatically when the workbook is opened/loaded. However, this type of Power View refresh shouldn't require the source database to be accessible; it should only need to read the data that's been already loaded into the Power Pivot model.

    When you experience this issue, is the data still visible in the Power Pivot window? The described behavior definitely sounds unusual...


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

    Website: nimblelearn.com, Blog: nimblelearn.com/blog, Twitter: @nimblelearn

    Tuesday, June 3, 2014 3:57 PM

All replies

  • Hi,

    Thank you for posting in the MSDN Forum.

    Since the issue is more related to the feature of PowerPivot, I'd like to move it to PowerPivot forum.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

    Thanks for your understanding.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, June 3, 2014 2:15 AM
  • Ping!!!

    For quick review of new features, try virtual labs: http://msdn.microsoft.com/en-us/aa570323

    Tuesday, June 3, 2014 2:37 PM
  • You are right that Power Pivot models are effectively an encapsulated/embedded SSAS Tabular database. Any data the you load into it is stored in it's entirety in the xVelocity storage engine. 

    Power View on the other hand gets the data in bite-sized chunks based on what you are viewing/interacting with. As you interact with the Power View reports/dashboards, DAX queries are being generated on the fly and sent to the Power Pivot model. As a result, Power View always needs to refresh manually or automatically when the workbook is opened/loaded. However, this type of Power View refresh shouldn't require the source database to be accessible; it should only need to read the data that's been already loaded into the Power Pivot model.

    When you experience this issue, is the data still visible in the Power Pivot window? The described behavior definitely sounds unusual...


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

    Website: nimblelearn.com, Blog: nimblelearn.com/blog, Twitter: @nimblelearn

    Tuesday, June 3, 2014 3:57 PM