Forum Discussion
Direct Query Filters in the report
Hi dobregon,
Why did you not use and in the query?
let
Source = Sql.Database("localhost", "Power_BI_Test", [Query="select * from Financial_1 where ID>50 and Year >= 2014"])
in
SourceHere I can get the result that filterd by ID and Year at one time.
Regards,
Frank
thanks for the reply v-frfei-msft but this is not a solution because the stakeholders of the report want to have a dynamic filter in order to see a period of time and type of element so I'cant use in the query.
The problem is that my database has a lot of rows and if i do a import query the system needs more than 7h to upload all the data and we need to do every day so, the import query can't do that.
The directy query seems to be a good solution becasue if the people needs to filter Period of time and type element and then wait 10-30seg it is a good solution but the problem is if i have 2 slicers the system will run the direct query when the people change any slicer instead of wait to finish the selection of the 2 slicers and the run the query. For that i'm asking if they could be a bottom to apply both filters at the same time.Hi dobregon,
You can use Filter in the Field to filter more than one columns at one time.
Regards,
Frank
hi v-frfei-msft i know this option but it is similar to filter using slicers (and connecting them in all the pages). the problem is that I need filter "dates" (with start and end) and types, so in this case i need to have 2 filters (same than slicers) but in this option i need to click "apply" individually so, i'm in the same problem.
I'm trying to look how to do using a SP with parameters but i can't find a solution yet
