Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
here is code snippet that might help if there is some confusion.
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.