7 thoughts on “Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches

  1. Pingback: Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches - SQL Server - SQL Server - Toad World

  2. Pingback: Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches - SQL Server - SQL Server - Toad World

  3. Hi Paul,

    Have you try to deploy your model (database) with a different name?
    Then you could backup the deployed database and restore it to the correct database without overwritting the roles.

    I think that would work.

    Regards,
    Tiago Rente.

    Like

    • Tiago, that does work. Thank you. I suppose it’s a matter of jumping through different hoops but this method doesn’t require scripting and reapplying the roles. Thanks

      Like

  4. “On occasion, Excel will just shut down or not allow the xlsx file to be saved.”…
    Is this the “Excel encountered a problem…. Autosave has been disabled for the remainder of this session” error message that just randomly pops up in Excel? And from then onwards it is impossible to save the file. I have had this reasonably often over time and found it annoying to say the least. Interestingly, on a couple of occasions I was able to save the file under one of the other file formats, but this doesn’t always work.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s