Forum Discussion
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 f...
Anonymous ,
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.
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.