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

Query loads two times, bug or error?

Dear Users,

I have a problem regarding refreshing my data in Power BI. The problem is that when I refresh my data, the query (…Office) loads twice this takes so much time and my question is; can I fix this or is this a bug?

 

I have added a screenshot from my advanced editor, because there are quite some things that had to be manipulated. I think that if there's an error it because of one of the steps after 'Rijen gefilterd'. I had to create two tables and perform some steps on one of them, I have combined them again later on.

 

1.JPG2.JPG

2 REPLIES 2
Community Support Team
Community Support Team

Re: Query loads two times, bug or error?

@Tour ,

 

It seems like there're too many rows/columns in Q2.xlsx, I would suggest you to remove some useless rows/columns and check if this issue persists.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Tour Frequent Visitor
Frequent Visitor

Re: Query loads two times, bug or error?

Hi @v-yuta-msft

 

First of all thanks for your reply, however Ive tried to delete empty rows from the sheet but the query is based on solely the table, thus it didnt have any effect. The table doesnt have any empty rows / columns either. Every quarterly sheet has around half a million sales lines, which explains the big sheets. 

 

Im pretty much clueless about the cause now.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 343 members 3,712 guests
Please welcome our newest community members: