Enable Load creates an issue with tables

[allejot]

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

[Pragati11]

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.

1. Try merging these tables a s a new table in Query editor.
2. Then disable their load in Query Editor.
3. Just bring in the MERGED table.

Thanks,

Pragati

[v-lionel-msft]

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.

[v-lionel-msft]

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.

[allejot]

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...

[amitchandak]

@allejot , refer if this can help

https://www.thebiccountant.com/2016/11/08/speed-powerbi-power-query-design-process/

[allejot]

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.