Hi Please check whether there existing any step in Power Query consuming too much CPU or memory. However when I click 'Refresh' on the ribbon in Desktop it takes over *25 minutes* to refresh the data!! I can see by the progress box that all the rows load within a few seconds but the Portfolio table states that is importing ' X.X MB from This number stalls and I tend to cancel the refresh but even cancelling can take 7 or 8 minutes - just to cancel!Ĭlearly something isn't correct but I've researched and tried several commonly suggested issues (looking at performance of individual visuals etc) but it doesn't change the very slow refresh.Īny advice? Is it the report? Or should I be looking at the Sharepoint site? It has 4 calculated columns and 4 measures. This source has c.250 columns of which I import 11. The data source for the Portfolio table is a Sharepoint Online list. One table 'Portfolio' contains the main data for the report but even that only has 1076 rows. It contains 5 tables most of which are <20 rows and <20columns. I have built what I think is a relatively small report in PBI Desktop.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |