Forum Discussion

KellyPorter's avatar
KellyPorter
Frequent Visitor
6 years ago
Solved

Data source access error Analysis Services Stopped Working When Updated Password

I have a published Power BI Report that points to a SSAS Tabular database. It worked fine for an extended time up until we updated the password on the admin account.  Now the report is blank and show...
  • KellyPorter's avatar
    KellyPorter
    5 years ago

    Thanks for your response, Greg_Deckler .  I did try that, and no luck.  The issue turned out to be that the password had not been updated for the services in SQL Server Configuration Manager.  Once I got that updated and restarted services, data started populating in my reports again.  It had not occurred to me to check the configuration manager, as the data source in the gateway indicated "connection successful" when slearly it was not.

KellyPorter's avatar
KellyPorter
Frequent Visitor
5 years ago

Thanks for your response, Greg_Deckler .  I did try that, and no luck.  The issue turned out to be that the password had not been updated for the services in SQL Server Configuration Manager.  Once I got that updated and restarted services, data started populating in my reports again.  It had not occurred to me to check the configuration manager, as the data source in the gateway indicated "connection successful" when slearly it was not.

v-lili6-msft's avatar
v-lili6-msft
Community Support
5 years ago

hi  KellyPorter 

It's pleasant that your problem has been solved, 😁 please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.

 

Regards,

Lin