Forum Discussion

LuiSMSR's avatar
LuiSMSR
New Member
2 years ago

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 ...
Dataflow
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

1. why are you using an ODBC connection rather than the default Sql.Database()  connector?

2. Have a fixed connection string, for example to the 2023 database.  Then in your custom queries specify a different database as needed.