Forum Discussion
Data source access error Analysis Services Stopped Working When Updated Password
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 - Probably not but maybe try updating the data connection in the PBIX file. Otherwise, You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
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.
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
