Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm using a direct query PBI SQL query with DECLARE statement.
It throws me an error saying that
Incorrect syntax near the keyqord DECLARE. Incorrect syntax near ')'
The SQL statement is as follows:
DECLARE @effect_date as date;
Set @effect_date= (select distinct effective_date from io.indirect_cost_ratio)
select * from io.inouttable
how can I get DECLARE statement to work in direct Query mode?
@Anonymous , where are you using this @effect_date date? this, you can use as a sub query.
Also checking after using this query is it still working on power bi service.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |