Forum Discussion
Need Advice: Import Mode versus Direct Query (or composite) for Small Enterprise reporting
Hello Community - I am in a debate with our sysadmin as to which way we should go for our enterprise reporting initiative. I do the reporting in Power Bi and we do have a lot of custom calculat...
Oh, then my initial suggestion on how to talk to your IT guy is a bit moot. You're not paying by usage, are you?
lbendlin We are a relatively small company ($150 million), but owned by a much larger company (billions). We have premium accounts (myself and the sysadmin) and can create premium workspaces. Ideally any source we would need to connect to (dataflows, Excel, 3rd party sources, etc) we would connect via APIs and dataflows to "import" the data using import mode. So, for example, if we had an existing golden dataset and we needed to augment it, we would bring in the new source via import mode.