Forum Discussion
Date parameters in SQL query
Hi, I have a large table in SQL with data that are growing pretty fast. I don't want to import the whole thing to Power BI, just to choose from slicers the start and end dates and get only the data ...
If you are using import mode please check this post: https://community.fabric.microsoft.com/t5/Power-Query/Dynamic-Date-Parameter-for-Import-Queries/m-p/1428793#M44641
Other option is using direct query. With direct query the data remains on your server and the PBI send the query request data when you filter the visual