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...
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?