Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I extract data by SQL from ODBC. This is something like financial data that filtering by department number, extracting monthly expenses. I filter in SQL by using WHERE T1.DEPT = 'A00' (assume A00 is department number).
Due to the data is quite huge, I only extract the expenses for a few departments each time. When want to change the filter, I will need to open up the 'change data source' to edit SQL Query. Is there any way or any button to help in changing the filter query where I don't need to open the source each time to change query but can change the filter in a field, as I only want to change department number filter in SQL each time
Solved! Go to Solution.
Yes you can add a parameter, right click somewhere on your query viewer and choose new Parameter:
as Current value you can put 'A00' (without the quotes)
now you can use this parameter in your sql query, something like this:
= Sql.Database(".", "AdventureWorks2016", [Query="select AddressID, City from Person.Address where City = '"& param & "'"])
Hi @Anonymous ,
It seems that you want to use parameter in power query, right? If so, you could refer to Pass-parameter-to-SQL-Queries-statement-using-Power-BI and power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/ for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
It seems that you want to use parameter in power query, right? If so, you could refer to Pass-parameter-to-SQL-Queries-statement-using-Power-BI and power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/ for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes you can add a parameter, right click somewhere on your query viewer and choose new Parameter:
as Current value you can put 'A00' (without the quotes)
now you can use this parameter in your sql query, something like this:
= Sql.Database(".", "AdventureWorks2016", [Query="select AddressID, City from Person.Address where City = '"& param & "'"])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |