Forum Discussion

reggdsouza's avatar
reggdsouza
Frequent Visitor
8 years ago

Deploying model using SSAS wizard

Deploying SSAS solution using the SSAS wizard removes the password form the .asdatabase file. We have to connect to the SSAS database and update the password manually, one by one, once the deployment wizard is run. Any ideas on how to make sure the SSAS database is deployed with the password in place?

Need Help
Show and Tell

9 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    8 years ago

    reggdsouza

     

    Are you using Power BI Desktop to get data from the SSAS database? Could you please post some screenshots for your problem here?

     

    Best Regards,
    Herbert

    • reggdsouza's avatar
      reggdsouza
      Frequent Visitor
      8 years ago

      Yes, we use power bi desktop to retrieve data from the SSAS model.

       

      The error is pretty generic. Screenshot below:

       

       

      This is fixed by going to Management Studio, and updating the connection password for the SSAS model being used. It wourked on version 16 of the deployment wizard. We recently installed the latest version(17), where this issue occurs.

      • v-haibl-msft's avatar
        v-haibl-msft
        Microsoft Employee
        8 years ago

        reggdsouza

         

        Are you using the built-in SQL Server Analysis Services database connector in latest version 2.52.4921.581 (November 2017)?

        What is the details content by clicking "Copy Details"?

         

        Best Regards,
        Herbert