Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Direct query - DECLARE Statements

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?

1 REPLY 1
amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.