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...
Neither Import Mode nor parameters are relevant to this scenario.
So what could be relevant then?
Have you switched the live connection to direct query?
I thought that direct query is already live connection, what is the difference?
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.