Microsoft Power BI can be quite slow when working with data sources that aren't from a data warehouse or a more robust source or data artifact. When working with exports, which we do frequently, the load takes considerable time. This occurs with any BI tool, and it's related to our working methods due to limitations within the area. In HR, we typically use exports because we have numerous data sources. Ideally, Microsoft Power BI would have a no-code or low-code solution for the data sources to be built by the actual developers or development team. This would eliminate the need to work directly with exports. We would have a middle ground to create a warehouse without all the infrastructure, as building a warehouse within an organization can require substantial resources, both in time and personnel.
