Forum Discussion
Unable to read data from the transport connection error
The solution which I have implmenented to complete all my reports was, I created "Query" instead of "Page" in Business Central and then I loaded all the queries in Power BI.
This helped me to complete all the process very smoothly.
Helper IExactly the same issue:
- read two fact tables from Business Central
- some operations: filters, column selections, replaces, calculations
- merge of those two tables
- group by
Fact tables are small (about 100k lines), so that shouldn't be the problem.
These operations make virtual memory grows as crazy.
A computer with 16GB can process it in desktop
A computer with 12GB cannot
Refreshes in service sometimes cannot do it
We have tried:
filters (short term solution. Next year the problem would be back)
buffers and stopfolding, some tiems work, sometiems don't
We need a solution for that
Helper IFinally I could make it work
We had to add Table.StopFolding every where
And now it works
It looks like some optimizations folded into the source system were unfeasible after the update