Forum Discussion
One or more tables reference a dynamic data source.
Hello, I have searched on community, on google and with the help of ChatGPT and I am still not able to fix my query. I am connecting to an Sql.Database on PowerBI Service. This particular Database ...
Hello lbendlin, thank you for your response.
Why do you think I'm using ODBC connection? In my formula I have Sql.Database connector, and my data is brought by a SQL server.
I did not understand 2. Do you mean I create a parameter with value "CTA2023" and in my query i change it as needed? What I want is to have CTA+year we're at without going to the query and change it myself.
You use a connection string, That is not necessary, it is sufficient to specify the server name.
Sql.Database - PowerQuery M | Microsoft Learn
My suggestion is to create a connection against database A but then in your native queries you can reference database B on the same server assuming you have permissions to both databases.