Can Ssis Update Excel Powerpivot Models

Remove From My Forums

powerpivot data model inside a separate file?

Question
Is information technology possible to connect to a powerpivot-data-model and information inside 1 excel-file, from a pivot tabel inside another excel-file?

Why do I enquire this question, you may wonder?

Well, I am looking for an easy to use datawarehouse-solution. The SSIS and SSAS solutions may exist to big for me to larn in a short time. But I want to maintain my datawarehouse information model only once. Although Powerpivot is meant for Adhoc-reporting, I don't think it will be used that fashion. My users volition want to keep their pivot tabels (and therefore their Excelfiles with data models).

And so after a menstruation of time, I volition be stuck with many (the same) information models. So when the data model changes (considering the source information model changes), I volition take to change many information models, and I don't want that.

I realize the functioning will not be equally good, simply I want my data model inside one Excel file (and no pivot tables inside this file), and on the other hand many Excel files with Pivot tables all referring to the same Excel-data-model-file.

What is your stance on this? I promise y'all have better ideas, considering I dont even like this solution (if it is fifty-fifty possible). But the thing is, I want to maintain my data model in 1 place.

Answers

The PowerPivot cube has to be in the workbook unfortunately. SSAS is the solution for what you describe.

You could always build the data in a standard Access RDB or SQL server, and build the PowerPivot model from these. You would still have many models, but just i data source, so information technology would be a chip more controlled.

"Leonvr" wrote in message news:fa3cd093-65db-4506-adab-662924b7738d@communitybridge.codeplex.com...

Is it possible to connect to a powerpivot-data-model and information within one excel-file, from a pivot tabel within another excel-file?

Why do I ask this question, you may wonder?

Well, I am looking for an like shooting fish in a barrel to use datawarehouse-solution. The SSIS and SSAS solutions may be to big for me to learn in a brusk time. But I want to maintain my datawarehouse data model simply once. Although Powerpivot is meant for Adhoc-reporting, I don't think it will exist used that style. My users will want to keep their pivot tabels (and therefore their Excelfiles with data models).

So later on a menses of time, I will exist stuck with many (the same) data models. So when the data model changes (because the source data model changes), I will have to modify many information models, and I don't want that.

I realize the performance volition not be as good, but I desire my data model inside i Excel file (and no pin tables inside this file), and on the other manus many Excel files with Pivot tables all referring to the same Excel-information-model-file.

What is your stance on this? I hope you have better ideas, because I dont even like this solution (if it is even possible). Merely the thing is, I want to maintain my data model in 1 identify.
- Marked every bit answer by Sunday, November 3, 2013 11:48 PM
Hello,

is saving your PowerPivot model to Sharepoint a solution? From hither your users can utilize the model without duplicating the model.

Tom
- Marked as answer by Ed Price - MSFT Microsoft employee Sun, November 3, 2013 11:48 PM

Can Ssis Update Excel Powerpivot Models,

Source: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fa3cd093-65db-4506-adab-662924b7738d/powerpivot-data-model-inside-a-separate-file?forum=sqlkjpowerpivotforexcel

Posted by: kiferfrimply.blogspot.com