We're running PowerBI Pro and have built out a scorecard that sources mostly from flat files stored in a SharePoint doc library. The query/build process is fairly complex and has been running well without exception until just recently. During the last 5 days we've seen a huge increase in "Unexpected Error" errors while refreshing from mostly unchanged sources in the Edit query mode.
The big annoyance is twofold with regard to the error traps;
1. When the query gets an "unexpected error" an option is "Retry" which we do, usually resolving the issue with said query. What is this telling us? How can a query be no good, then it's fine withouit any intervention by us??
2. When we're refreshing from the front end the app kicks a "there's 251 errors in 251 rows out of 500 rows", when we research in the query side, the error group is an empty table with no errors or clues to be found.
