Forum Discussion

GustavO65's avatar
GustavO65
Icon for Helper II rankHelper II
6 years ago

How to use Filters in database queries?

Good. I need to use the From/Until I select the query user in SQL syntax to fetch data. You could initially run the query to the SQL server by taking the last 30 days as a default search. But t...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I assume you're mode you are fetching the data is set to DirectQuery. Is that the case?

If so, then you simply need to set up your visualization along with the date slicer. PowerBI will automatically append your query with the approproate WHERE clause to narrow your query.


Keep in mind that Power BI does have a 1,000,000 row limit on data returned from a database when in DirectQuery mode. It doesn't sound like you will be anywhere close to that.

Also, for performance reasons, make sure your filtered query can return in < 5 seconds.

GustavO65's avatar
GustavO65
Icon for Helper II rankHelper II
6 years ago

Hello @jptak

Thank you for your answer..

I'm sando QueryDirect..

How do I do/define this that you tell me? you just need to set up the display along with date segmentation

Apologies but I'm new to PowerBI and I'm trying to migrate my reports made at Reporting Services to use the full power of PowerBI in handling information...

Best regards