Forum Discussion
Helper IVparameter controlled by slicer
Helper IVThanks v-lid-msft , I wasn't aware of query string parameters, that's great. It appears this can filter the number of records, but I'm trying to filter the number of columns, so as to give the user a choice of columns to choice from in the report, would there be a way to do this ?
Community SupportHi richard_wylde ,
The key is the storage mode of fact table, if the fact table is in Direct Query Mode, it will retrive data based on the slicers, filters,interactor, or url string parameter(actually it is kind of page filter), so it is will automatically send query like select ... from ... where column A = ... and column B = ... , based on the silcers and filter user select.
But if the fact table is in import mode, the data will only refreshed when execute an on-demand refresh or scheduled refresh, it will also filter data by slicer or filter if you import all the data in (mean no query parameter applied in the query), it will not query the source to get newest data when slicer or filter changed.
So in conclusion, if you want to get the latest data and do not want to import all the data, you can try to put the fact table in Direct Query Mode, please refer to this document: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
Best regards,