Forum Discussion

allejot's avatar
allejot
Frequent Visitor
6 years ago

Enable Load creates an issue with tables

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

Need Help

6 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    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

    • allejot's avatar
      allejot
      Frequent Visitor
      6 years ago

      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.

    • allejot's avatar
      allejot
      Frequent Visitor
      6 years ago

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.