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 😄
v-yetao1-msft
on:
Power BI service uses incoherent query caches
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