Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I am creating a model and I am running into Memory issues.
Here the setup:
- I use we service to connect to some Business Central sites (one for each company)
- I retrieve just the tables I need
- I merge the tables (same structure among companies) from the different companies into one
In order to save some memory, I disable "Enable Load" as I will onmly need the table for all companies combined, not the temporary table.
When I load the model, each table "fails to resolve the name of each temporary table".
Any suggetion how to solve this?
Thanks,
Alex
Hi @allejot ,
Are the table names in your UNION statement right?
Also ideally you should merge them in Query editor, so that ou can disable the tables load (used for merging) in Query Editor.
Looks like you have disabled the Load of all the tables used in this UNION statement.
Thanks,
Pragati
Hi @allejot,
Has your problem been solved?
Did you hide the temporary table first and then use DAX to get the calculated table?
Like this?
Step1
Step2
You should combine the tables in ‘Edit Query’ and then cancel the ‘Enable load’ feature.
My guess is that your process of combining tables is incorrect.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @allejot ,
Please refer to the article.
Performance Tip for Power BI; Enable Load Sucks Memory Up
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did refer to that article when disabling "Enable Load".
The issue is that by disabling "Enable Load" the table shows the error on the image I posted...
@allejot , refer if this can help
https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/
not exactly the answer to my question. I read your post but I do not want to go down that way. I want to simply not load many temporary tables.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |