cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shmulikvarsano
Frequent Visitor

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

8 REPLIES 8
Moderator v-yuezhe-msft
Moderator

Re: 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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shmulikvarsano
Frequent Visitor

Re: double loading when source = table

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

Moderator v-yuezhe-msft
Moderator

Re: double loading when source = table

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
shmulikvarsano
Frequent Visitor

Re: double loading when source = table

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.

 

Moderator v-yuezhe-msft
Moderator

Re: double loading when source = table

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shmulikvarsano
Frequent Visitor

Re: double loading when source = table

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.p4.PNGp1.PNGp2.PNGp3.PNG

Moderator v-yuezhe-msft
Moderator

Re: double loading when source = table

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

1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shmulikvarsano
Frequent Visitor

Re: double loading when source = table

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors