i have recently got an issue with Power BI Desktop ( Version: 2.69.5467.2151 64-bit (May 2019) )
I opened a PBIX file to update a report an republish it, i didn't finished my changes so i saved the document
to continue later, now i cant get the saved pbix file to open.
My reports only use one datasource, an sql data source.
Failed to save modifications to the server. Error returned: 'Login failed for user ''.. The exception was raised by the IDbConnection interface.
A connection could not be made to the data source with the Name of '5556bb6e'
I made the experiment of opening a working copy of another report, just click save and close the file, and retry opening the file with the same error results.
In the SQL logs i can see a all of the failed connection attempts for user '' (empty) so it seems the latest power bi desktop is not saving the report credentials correctly, nor is allowing to re-introduce them at loading the file, nor it is finishing opening the report so you can fix the querys.
The SQL Server says the server is configured for windows autentication only but that is not the case, it is correctly setup to accept both windows and sql autentication.
So when i open the report, there is an actual attempt to get the data, but the credentials are wrongly saved.
Does anyone knows a way to bypass the saved credentials in the report for the datasources, as if i open any file make changes, publish them, i will loose my pbix file as it is saved when publishing making it inaccesible later for any further changes.
I can't neither download a pbix copy of the published versión of the report, as i get the same errors at opening the file.