Forum Discussion
scaramangamp
9 years agoFrequent Visitor
Slow PowerBi Desktop Refresh
Hi, I have a PowerBI file with 10 data sources, some Web, some ODBC some local files. The Web files are very large (40MB) however I only select a few columns. There are till 30,000 + rows. W...
MattAllington
9 years agoCommunity Champion
I'm thinking it could be a query folding issue. Reza Rad blogged on this topic this week. Read about it here and see what you think.
http://radacad.com/not-folding-the-black-hole-of-power-query-performance
otherwise, time to debug with a bi are search. Create a copy of the workbook and delete half the queries. See if the problem persists. Try again with the other half. Chip away and try to find if it is just one or two of them, then go from there