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, Lin.  I had tried that as well, but 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".