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...
So what could be relevant then?
Have you switched the live connection to direct query?
Live connection = you must use their data model, warts and all
Direct Query = you can use their data model but can also make adjustments and add measures (and row level columns)
Import Mode = the data is now yours, do with it what you want.
I thought that direct query is already live connection, what is the difference?
Ahh ok thanks for explaining it so simply
But no other solution for the asked problem is possible?
I am not sure there is an actual problem?