What user should be used when importing a Power Pivot model into SSAS tabular? RRS feed

  • Question

  • I created a Power Pivot model using my own userid.

    In SSDT I can import that model but it saves the model in my own My Documents folder. In SSMS, other users can browse the data in that model.

    If I tell SSDT to save the model in the Public user's My Documents, the model is not visible in SSMS for anyone to see.

    If a colleague imports the model, it can be seen in SSMS but there is no data when it is browsed.

    There seems to be a tie up with the user id I used when the model was first created. Is it possible to break that link, or should we have a user id specifically for creating and deploying Power BI models via SSAS tabular?


    Thursday, April 30, 2015 2:02 PM


All replies