Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Failed to save modifications to the server2 datasource reference(s)

So I'm trying to connect two different databases from SQL to Power-BI using parameters created in power-BI using direct query, when trying to do this in direct query it's giving me this error, but not when I'm doing an import. It's preferable that I use direct query to limit the filesize so I'm wondering why this is not working?

 

Here is the error 

 

1ce9a3c00467f0c878dc8082774251bc.png

here is code snippet that might help if there is some confusion.

c3bbdfc289379894b79dfa115286090a.png

1 REPLY 1
lbendlin
Super User
Super User

You have blacked out the part that is important.  It is not clear if you override the server name or the database name. 

 

(You may get away with the latter but then you should use Sql.Databases  (extra s)  which in turn is not supported in the gateway.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!