insufficient memory to complete this operation

Hello,

I found the solution to the performance problem.

First, My power bi file called an external dataset in a dataset that takes more than 5 hours to refresh. This was causing a memory saturation problem. The solution was to separate the visual part from the dataset and call the dataset that was causing the memory saturation problem from the visual dataset.

Secondly, on the dataset from my Dynamics 365 CRM source. I created tables so as not to use the Table.ExpandRecordColumn function on large tables, but to use the Table.NestedJoin and then Table.ExpandTableColumn functions to retrieve the necessary information. This limits the number of calls to the webservice and avoids repeated attempts to connect to the webservice. The loading time was multiplied by the multiple connections to the Dynamics 365 webservice.

Thirdly, changes to my desktop file, which was currently being modified, were not being taken into account. So I opened the pbix zip file, deleted the UnappliedChanges file and reapplied the M code to each of my tables.

The result is a drop in loading time from over 7 hours to 48 minutes on powerbi desktop and powerbi services.

The dataset file still contains the 130 tables required.

Thank you for your help