I'm on Version: 2.106.883.0 64-bit (June 2022) of Power BI Desktop, and have a working report pulling in data from 3 different tables from a 2017 SQL Server database.
When I open the report and say change data source to a different database on a different server, where the data structure is identical and the data is almost identical (the only difference is the created_at and updated_at columns depending on when the data was crunched) Power BI tries to open a connection to the new database using my Windows credentials (same as old DB) and fails to connect.
What is strange is if I create a new report and go to the new database server and database, the same credentials work fine and I can access exactly the same tables that I cannot update from the old report.
To rebuild the entire report would be painful just to change the database source - is there an alternative? I have tried on a couple of different PCs (virtual workstation in cloud and organisation laptop) but I get the credentials error each time when changing source but can open the database and tables with no issues using the same credentials.
Please do suggest how I get more diagnostic information to help you to help me 😄