Forum Discussion

santiagomur's avatar
santiagomur
Resolver II
6 years ago
Solved

use parameters in sql query to import data

hi,    i`m trying to use parameters to import data, what i need is to use parameters to change de WHERE in de query.  I am creating a theme and i want that when i open it they ask me this paramete...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • JirkaZ's avatar
    JirkaZ
    6 years ago

    Anonymous And here you go - Feb update with Incremental Refresh for PRO users 🙂

amitchandak's avatar
amitchandak
Super User
6 years ago

Check if these can help:

https://community.powerbi.com/t5/Desktop/Using-Advanced-Query-and-parameters-to-create-dynamic-SQL/m-p/914235

https://community.powerbi.com/t5/Desktop/SQL-parameters-in-direct-query/m-p/248180

https://community.powerbi.com/t5/Power-Query/parameters-to-SP-or-Sql-query/m-p/57734

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin