Forum Discussion
RobG123
4 years agoHelper I
Query Errors taking forever to load
Hi, I appended two datasets, one with about 10,000 rows and one with around 3,000. I know that the column headers aren't all the same so expected to get some errors. But the query errors istaking...
- 4 years ago
Are we talking about the actual append query taking so long, or are we talking about one of the auto-generated 'Errors in query' queries taking this long?
The auto-generated ones never load the first time you select them, you usually need to close PQ down then reopen it and it will load straight away.
Pete
RobG123
4 years agoHelper I
Thanks that worked. I don't understand why though! It seems like odd behaviour from PowerBI
BA_Pete
4 years agoSuper User
It is odd behaviour.
To you or me it's obviously not working correctly but I'm sure if you asked someone from MS they'd explain how it's a "feature" somehow 😂
Pete