I'm currently having issues with my PBIX performance (It always crashes). In my current setup, I'm using 4 Excel files with multiple sheets as data sources. But I didn't experience these crashes before when I'm connecting to around 3 tables from a Database (SQL). And the number of rows is much larger in the database compared to what I have in Excel.
Is there a whitepaper or reference relating to Power BI performance when considering what data source to use (particularly Excel and database)? Or do you have any idea if a type of data source can be a factor to performance?