Forum Discussion
Options for getting only preffered data before loading into power bi
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?
When you connect to a Power BI dataset it may initially be a live connection. You can change that to a Direct Query connection with local model (link in bottom right). That will also allow you to pick individual tables from the data model. You can also rewire the data model if you want, by loading individual tables one by one.
Hmm i dont think this is the answer im looking for, because we don't want to change it to import mode.
Also when having a directquery connection, would using parameters maybe be of any help for this to only take what is needed from the created dataset and then only load that into the model?
