Variable in a Power BI query

Question

I am using a SQL query in power bi

select a,b,c,d from table1 
where a in ('1111','2222','3333' etc.)

How can I change the list of variables whenever I refresh the data ?

Answer 1

Create a new query to read "values" and then set import data to Only Create Connection, to avoid duplication

In SQL Query remove the clause

Check out our Power BI Course to have a complete grip on Power BI concepts.

Intellipaat's Power BI Developer blog will guide you on how to take on the profession.