On the face of it, it seems like a great idea to leverage SharePoint as a storage location for CSV and Excel files.
– Everyone has easy access to the files for editing and storage
– SharePoint manages version control, check in, check out etc
– SharePoint can facilitate shared editing of files
– You can build a Power BI report that will refresh online without the need to install a gateway.
Unfortunately, despite the benefits, the experience is not great. Power BI performance with SharePoint as a data source is simply terrible. Ultimately, the problems come down to performance in 2 areas.
Read on to learn more about these two issues and what you can do instead.