Forum Discussion
ddalton
Resolver I
4 years agoLimiting data import when switching from DirectQuery
Hi, I need to switch my dataset from DirectQuery (DQ) mode to Import mode (as per a notice in Power BI Desktop telling me that a step is not supported by DQ mode). My concern is that the dat...
- 4 years ago
Date filtering (i.e., limiting the data loaded into the dataset) and the use of slicers (dynamic date filtering for visuals) seem to do the trick for now.
ddalton
Resolver I
4 years agoSo, for now, I'm using a relative filter on the respective date/time columns in the dataset to filter for 6 months worth of data but I'm still hoping for some advice, if anyone has any other suggestions - particularly regarding my last statement i.e., allowing Service users to change the date frame.
ddalton
Resolver I
4 years agoI've also just discovered slicers which appear to allow for the filtering of graph data by date, which I presume can be used by Service users viewing the reports online.