Hello everyone,
I'm trying to use the ODBC DirectQuery option in PowerBI, but I keep getting an error about another command. The SQL query works while using the SQL Editor. Do I need to change the setup of my ODBC connector?
DECLARE dateFrom DATE = DATEADD(YEAR, -1, GETDATE());
SELECT dateFrom AS dateFrom;
HI thanks for replying. I tried also query the same command in python using SQL class but without any success.
SQL machine is configured correctly and works with PowerBI, Python if user query only one command. We would like to use parameters and create final query from other selects. Do you think it possible to use more than one command per query?
