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...
lbendlin
Super User
Super User"would connect to those using "live connection". Try to stay away from direct query. "
Nice(*) idea but not enforceable. Composite models allow you to bend live connections into direct query with local data model copy. This is a rather required feature as soon as your report connects to more than one golden data source
* - said in jest. One of the biggest aspects of what we are doing is the fundamental question "Are we trying to promote the usage of Power BI or are we trying to make it harder for the users?" . If you are getting in the way of the users' quest for actionable insights then they will go elsewhere and you have failed.