Forum Discussion
Options for getting only preffered data before loading into power bi
Hi, When creating power bi reports or dashboards, most of them are linked directly to the datawarehouse where we have full control over what query to write in order to get only data we need. But for...
As I understand it you are already using Direct Query. No data is loaded into Power BI until the user interacts with the report pages and visuals.
Are you looking for the aggregation function?
Hi lbendlin , im not sure if im understanding what the aggregation function is.
THe thinh is one create dataset is used for 2 different reports, but we dont want to change any of data already available in the created dataset, so what other option is there to use the same dataset but just take needed data from it before it loads into power bi?