Forum Discussion

RobG123's avatar
RobG123
Helper I
4 years ago
Solved

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...
Need Help
  • BA_Pete's avatar
    BA_Pete
    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

BA_Pete's avatar
BA_Pete
Super User
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's avatar
RobG123
Helper I
4 years ago

Thanks that worked. I don't understand why though! It seems like odd behaviour from PowerBI

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

     

    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