Forum Discussion
Sharepoint Folder Query "Error"
Hi mebiza,
Thank you for the follow up.
Based on my understanding, since the View Errors window is blank and there are no red or error columns visible, please perform the checks below to help determine whether this is an environment/UI issue or an actual query error.
- Open the Query Editor, go to Tools and choose Start Diagnostics. Reproduce the refresh or the step that displays the blank error dialog, then select Stop Diagnostics. The diagnostics output will indicate where Power Query reported an error even if the View Errors UI remains empty.
- In Power BI Desktop, go to File → Options and settings → Options. Under Diagnostics, enable tracing and select Collect diagnostic information. Reproduce the issue, then save and examine the trace files written to the local traces folder. These logs frequently reveal internal error details when the UI does not.
- Open the PBIX file on another machine or update to the latest Power BI Desktop build from Microsoft and reproduce the issue. If the problem disappears on another machine or after updating, it is likely an environment specific issue or a bug resolved by updating or reinstalling.
We hope the information above helps resolve the issue. If you have further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
Hi mebiza,
I see your errors query is set to keep errors, which is why rows continue to load.
Are you able to see what columns have errors? They should be marked red.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
There are no actual errors, there is only 2 rows on the query the filter is the one Power Query automatically adds to display the errors only but there no actual errors showing on power query
Hi mebiza,
If you click view errors on that last screenshot, what comes up?
And on the right hand side, what transformation does it indicate as having an error?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.