Cannot change data source to a different SQL Server even though the database tables are identical

[brmerritt]

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 😄

[Anonymous]

Hi @brmerritt 

When we connect to SQL DB , we need to enter Server name , Database name and credentials , so if you change data source to different SQL DB , can you make sure these info are same ? 

If Server name and Database name are different , you need update them in Power Query Editor . I found some similar cases, you can refer to them .

https://community.powerbi.com/t5/Desktop/How-to-change-the-Data-source-connection-from-SQL-Server/m-...

https://addendanalytics.com/blog/change-database-server-directly-from-power-bi-service/ 

Best Regards,
Community Support Team _ Ailsa Tao