Forum Discussion

aroyappan's avatar
aroyappan
Frequent Visitor
9 years ago

How to pass values to variables declared in Power BI SQL Statement

I'm connecting to SQL server using direct query connectivity mode and diretly entering the query into SQL statement input field as shown below:     Here is the SQL statement:   DECLARE @Te...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

aroyappan

 

Try not to use variable in your SQL statement. It will not prompt out any window for input value for variables. In this scenario, you can use Query Parameter in the generated Power Query ( just go to "Advanced Editor" in Query Editor). For more details, see: Deep Dive into Query Parameters and Power BI Templates

 

Regards,

aroyappan's avatar
aroyappan
Frequent Visitor
9 years ago

v-sihou-msft

 

I have 10 million records in production. So I want to filter out before loading the data in power BI.

Is there a way for filtering data before loading?

  • dataviznz's avatar
    dataviznz
    Advocate IV
    8 years ago

    Does Power BI support this by now?