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
lbendlin's avatar
lbendlin
Super User
5 years ago

Tell him about the impact Direct Query has on the source system, with thousands of little queries constantly hitting the databases - versus import mode where you have a limited number of nice spools.  

 

The "golden data source"  concern is valid but it can be alleviated with shared / promoted / certified datasets.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    lbendlin   I think the way to go for us is to try and have all "golden datasets" built using import mode.    Any reports that get built (whether in the service or on desktop) would connect to those using "live connection".    Try to stay away from direct query.  

     

    Changes that a report author may need to make (adding a column or measure that did not prevoiusly exist in the core model) would have to be requested and then I would update the core model (dataset) accordingly, and re-publish it.    Does that make sense?