double loading when source = table

Question

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 load time of the project is double himselfehow can i fix this ?

shmulikvarsano · Answer

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

anonymous · Answer

shmulikvarsano,Do you mean that the data of the two tables are loaded into Report View when you click "Close&amp;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

anonymous · Answer

shmulikvarsano,
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/23901Regards,Lydia

shmulikvarsano · Answer

Thanks 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.&nbsp;

anonymous · Answer

shmulikvarsano,Do you mean that the load time from Query Editor to Report View in Power&nbsp; BI Desktop? If so, this is by design. If not, please post a screenshot about your scenario.Regards,Lydia

Forum Discussion

double loading when source = table

8 Replies

Related content

Count function is doubling

Data source

loading the source several times

Microsoft Load

SharePoint Source Evaluating won't load