Deploying model using SSAS wizard

[reggdsouza]

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?

[v-haibl-msft]

@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]

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]

@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

[reggdsouza]

@v-haibl-msftAny ideas on this? Were you able to replicate the issue?

[v-haibl-msft]

@reggdsouza

I don't see any issue when connecting to SSAS using the built-in Analysis Services connector. It seems that you're still using the July 2017 version of PBI Desktop, could you please have a try with the latest one - Version: 2.52.4921.581 (November 2017)?

Best Regards,
Herbert

[reggdsouza]

@v-haibl-msft

Lets step back a bit. After deploying an SSAS database using the SSAS deployment wizard in silent mode, we get a similar error when we try to run a MDX query in SQL Server Management Studio. We are using the latest version. 

Error below:

SSMS version:

Once we enter the password for the SSAS database connection in SSMS, the error goes away.

The process worked well in version 16. But in the latest version, it does not work as expected.

[reggdsouza]

@v-haibl-msft

Also tested with power bi desktop November release. Same Error. 

Feedback Type:

Frown (Error)

Timestamp:

2017-11-16T20:33:19.3968092Z

Local Time:

2017-11-16T15:33:19.3968092-05:00

Session ID:

b85ca938-4f1c-43d2-b8a8-8d8184ac1095

Release:

October 2017

Product Version:

2.51.4885.1041 (PBIDesktop) (x64)

Error Message:

OLE DB or ODBC error: Login failed for user 'INGR_READER'.; 28000.

OS Version:

Microsoft Windows NT 6.3.9600.0 (x64 en-US)

CLR Version:

4.7 or later [Release Number = 460805]

Peak Virtual Memory:

33.6 GB

Private Memory:

272 MB

Peak Working Set:

398 MB

IE Version:

11.0.9600.18817

User ID:

7bd88a03-cf1f-4357-aa6b-4187614edad6

Workbook Package Info:

1* - en-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:

True

AS Live Connection:

True

Performance Trace Logs:

C:\Users\qjaved\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Disabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_EnableReportTheme

PBI_numericSlicerEnabled

PBI_SpanishLinguisticsEnabled

PBI_daxTemplatesEnabled

CustomConnectors

PBI_reportBookmarks

Disabled DirectQuery Options:

PBI_DirectQuery_Unrestricted

Cloud:

GlobalCloud

Activity ID:

null

Time:

Thu Nov 16 2017 15:33:15 GMT-0500 (Eastern Standard Time)

Error Code:

QueryUserError

OData Error Message:

Failed to execute the DAX query.

DPI Scale:

100%

Supported Services:

Power BI Report Server,  Power BI

Formulas:

section Section1;

[Anonymous]

I have the same problem.

I cannot build the cube in SSAS thus not connect from PowerBI.

If I enter the User/Password in the DataSource again, it works.

So this is at least a workaround.

[reggdsouza]

Thats the error message when I do copy info. The whole issue is that it does not store the password on deployment, and we have to enter the SSAS database passwords manaully through SSMS. 

Feedback Type:

Frown (Error)

Timestamp:

2017-11-14T20:05:40.6905158Z

Local Time:

2017-11-14T13:05:40.6905158-07:00

Product Version:

2.48.4792.721 (PBIDesktop) (x64)

Release:

July 2017

IE Version:

11.674.15063.0

OS Version:

Microsoft Windows NT 10.0.15063.0 (x64 en-US)

CLR Version:

4.6.2. or later [Release Number = 460798]

Workbook Package Info:

1* - en-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:

397 MB

Private Memory:

297 MB

Peak Virtual Memory:

33.9 GB

Error Message:

OLE DB or ODBC error: Login failed for user 'INGR_READER'.; 28000.

User ID:

bb951106-ac1d-4ac8-a259-e55c1d8437fa

Session ID:

b57f17c7-a219-4b6f-9b6d-14b9a5e19870

Telemetry Enabled:

True

AS Live Connection:

True

Performance Trace Logs:

C:\Users\qjaved\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:

PBI_PbiServiceLiveConnect

PBI_daxTemplatesEnabled

Disabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_EnableReportTheme

PBI_numericSlicerEnabled

PBI_SpanishLinguisticsEnabled

CustomConnectors

Disabled DirectQuery Options:

PBI_DirectQuery_Unrestricted

Cloud:

GlobalCloud

Activity ID:

null

Time:

Tue Nov 14 2017 13:05:32 GMT-0700 (Mountain Standard Time)

Error Code:

QueryUserError

OData Error Message:

Failed to execute the DAX query.

DPI Scale:

100%

Supported Services:

Power BI

Formulas:

section Section1;