Forum Discussion
double loading when source = table
shmulikvarsano,
Do you mean that the data of the two tables are loaded into Report View when you click "Close&Apply" in Query Editor? If so, this is expected behavior. Unless you uncheck "Enable load" for Table2 in Query Editor, the data of Table2 will be loaded into Report View.
Regards,
Lydia
Table 1 load 300 XML file from folder and it take 10 minute. then I do some work on the data.
The source of table2 is table1 and now all the process take 20 minthe.
I see no reason why all the XML file loaded twice because I expect that table2 will take the data from the end of table1 and not from the beginning of table 1.
thanks
Please review the following similar thread about this behavior.
https://community.powerbi.com/t5/Desktop/How-to-Improve-Query-Reference-performance-for-large-tables/td-p/23901
Regards,
LydiaThanks for all the information. but i still feel that i have no good solution to my problem.
1. my question was on loading time and not run query time.
2. because i do lots of work on table 2 I cant use the solution of create calculated tables on the reporting.
3. I was expected that my tablet 2 will just take the data from the last step of table 1 and not start all the steps of table 1 from the beginning.4. becose table 2 depend on table 1 there is no reason why they run parallel. table 2 should start run only when table 1 finished her work.
shmulikvarsano,
Do you mean that the load time from Query Editor to Report View in Power BI Desktop? If so, this is by design. If not, please post a screenshot about your scenario.
Regards,
Lydia