Hello
I am working on a Power BI dashboard that pulls a years worth of data - to navigate the order status on the dashboard. Because they are millions of rows - i am using a direct query. For now am using a report level filter to filter out the order no i am looking for. The sql query used to build this dashboard is a scheduling query in the repository that gets updated in every 15 minutes.
Right now, because am using direct query - report level filter on order number - everytime when someone types the order number - it pulls all the data in the database and then filters it on the order number and shows me the result. Is there any other alternative where it doesn't have to keep pulling the years worth of data? Is there a way to pass a parameter on the order number? Does direct query in power bi allows you to pass parameters? If so, how?