Forum Discussion

shmulikvarsano's avatar
shmulikvarsano
Frequent Visitor
8 years ago

double loading when source = table

I have two tables: Table1 that load many XML files from folder and its take some time. I have table2 and the source = table1. The problem is that now all the XML files are loaded twice and the loa...
shmulikvarsano's avatar
shmulikvarsano
Frequent Visitor
8 years ago

Hi. Look at the file attached. as we can see the two table load parallel. so all the XML file loaded twice. this happen in the query editor and also in the power bi desktop.
The source of table 2 is table 1 to table 2 should behave similar to a view in SQL.

Thanks.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

shmulikvarsano,

The behavior you describe is by design. Unless you uncheck "Enable load" option or "Include in Report refresh" option for one of the tables, the queries will load twice.



Regards,
Lydia

  • shmulikvarsano's avatar
    shmulikvarsano
    Frequent Visitor
    8 years ago

    Thank for your answer.
    I still don't see the reason for this behavior.
    but if it's by design i will live with this.

    Thanks