I'm trying to improve the performance of my PowerBI report. It's currently taking about 3.5 minutes to refresh. I'm connecting to 6 different sharepoint lists. The data is used to feed 2 reports (separate tabs), which have different formats. After some research, here's how i set up my queries.
- Source 1 query (imports, minor transformation)
- Query for report 1 (reference to Source 1 query, additional transformation needed for report 1)
- Query for report 2 (referece to Source query, additional transformation needed for report 2).
.... and so on for all 6 sources.
Then i have a "master" file for report 1 that appends queries 1-6 and another one for report 2.
Here are the things I've tried, either individually or in combination with each other:
- quering the source once and then referencing in other queries (as seen above)
- enabling/disabling parallel loads
- adding Table.Buffer aroung the source for tables that start with a reference
- disable baground data
- grouping transformation steps
I'm not sure what else to try.
Additional info:
- The two reports must appear in the same workbook so separating them is not an option.
- The reports will eventurally published to an internal server.
