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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
OldN00b
Frequent Visitor

Pass through a list into a sql statement with parameter

I have a list from an existing query called "RiskDataSetID" which contains numerical values (i.e. 741,738,736....n). I created a parameter for this list and i am trying to implement it into the where statement of my sql query to try and limit the data i am pulling. I am running into an error which states "We cannot apply operator & to types Text and Number."

 

Here is the query i am trying to update using the parameter

select *

from db..databaseresults

where riskdatasetid in (RiskDataSetID parameter)

 

OldN00b_0-1664315716117.png

 

OldN00b_1-1664315752860.png

 

OldN00b_2-1664315859668.png

 

1 REPLY 1
talbot
Regular Visitor

You need to wrap your parameter call in Text.From()

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.