Could not change the data source to another DB on the same server

[arunbyc]

I tried to change the data source of a visual (abc.pbix)  from one database ("MyDatabase-Dev") to another database ("MyDatabase-Test") which is also on the same server using Parameters but that did not work. So I tried to change the data source manually to troubleshoot the issues.

I created a dummy visual in the Test database using one of the tables from abc.pbix.  clicked TransformData, copied the code from the "Navigation" step, and pasted it on the Navigation step of the same table in adc.pbix on Dev in power query editor.

I got an error message that "MyDatabase-Test" wasn't recognized. Make sure you spelled it correctly".

(This was the same message I received even when I tried changing the data source through parameters). But this time I did not even type the name. I cut and pasted it as above.

I then tried to do the same copy/paste the source name using the advanced editor instead of in the Power Query window.

I received a message that "Mydatabase-Test matches no exports. Did you miss a module reference?

I have to get the Reports to be tested in the Test environment soon. Can you please help how to resolve or troubleshoot this issue?

Thanks

AR

[rohit1991]

Ensure you can connect to MyDatabase-Test via SQL Server Management Studio to verify access and credentials. Go to File > Options and Settings > Data Source Settings in Power BI, clear permissions, and re-enter credentials for MyDatabase-Test. In Power Query, update the Source step to:

Source = Sql.Database("ServerName", "MyDatabase-Test")

Ensure the database name is correctly spelled. Create a new Power BI report and connect to MyDatabase-Test to confirm the connection works. Verify all queries use the updated parameter and not hardcoded values. If issues persist, involve your DBA to check server/module settings.