Remove Power Pivot Data Connection, or load data directly to model RRS feed

  • Question

  • Hi,

    Is there anyway you can load data directly to the Power Pivot data model, such as through SSIS, so that they user can utilize the data model but not refresh the data?

    Or can you remove the data connection without deleting the table within the data model?  



    Wednesday, August 21, 2019 5:30 PM

All replies

  • Alex,

    What is it you are trying to achieve?

    As far as I know you can't import a model, you would need to import all the tables, then build the model in "Model".

    I use a odbc/DSN as I find this easier to work with.

    Provider=MSDASQL.1;Persist Security Info=False;DSN=Example

    For a user to work with the model, they would need some data.

    This data would be available via pivot to do anything they wish. Assuming they do not have the DSN, "Refresh" would fail.



    Wednesday, September 11, 2019 8:29 PM