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...
"if we had an existing golden dataset and we needed to augment it, we would bring in the new source via import mode"
Who is "we" in this scenario? You and the sysadmin, or the report developers? You may want to plan to have some sort of a data stewart role (or team) in your company.
The "we" is me. Mostly. The sysadmin does not really create reports. At some point we may have some power users that we allow to create reports in the service, by connecting to a particular dataset. For example, we would have a "Quality Dept" dataset, and of their team may connect to that for ad hoc reporting needs.