Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks lbendlin     We do not have any on-prem datasources  (everything we'd connect to would be in the cloud, or we'd create a dataflow for it).   I'm definitely not an expert in this stuff, but it seems to me the beauty of dataflows is in their flexibility (you can make them from all types of different sources) and create datasets from them (using import mode exclusively).  

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.