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