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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.

Top Solution Authors