topic ODBC PowerBI 2 commands in one query in Data Engineering

ODBC PowerBI 2 commands in one query

mamiya — Thu, 02 May 2024 12:16:34 GMT

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;

Re: ODBC PowerBI 2 commands in one query

mamiya — Mon, 06 May 2024 07:04:28 GMT

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?