Sharepoint Folder Query "Error"

[mebiza]

Im working on a dashboard that gets data from files on sharepoint folder, and for some reason it would show an error during refresh, but the error would not actually display anything and data continues to load.

Is this a known issue? what can i do to get it fixed?

Files Query:

Errors Query:

Refresh Summary:

[v-pnaroju-msft]

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.

1. 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.
2. 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.
3. 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.

[mebiza]

The screenshot i uploaded is the actual one i get when i click view errors.

Nothing shows on it.

There are also no red columns neither on the actual query nor the errors table generated when i click view errors

[v-pnaroju-msft]

Hi mebiza,

We would like to follow up and see whether the details we shared have resolved your problem.If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @tayloramy, for your response.

Hi mebiza,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding, the refresh warning you are seeing may be caused by Power Query automatically creating a Kept Errors / Errors query or a step that captures row-level errors. Even if no visible errors appear in the user interface, the refresh summary can still flag them because the query is configured to retain error rows.

The main reasons could be:

1. A leftover Errors/Kept Errors query or transformation step is included in the refresh/load.
2. In SharePoint Folder scenarios, mismatched file schemas or early type conversion can also generate hidden error records.

Please follow the steps below which may help to resolve the issue:

1. In Power Query Editor, check for an Errors or Kept Errors query. Right-click and disable load, or delete it if it is not needed. Alternatively, uncheck Include in report refresh so it will not trigger refresh warnings.
2. If you want to view the actual error messages, expand the Error record (Reason/Message/Detail) in that query or use the try ... otherwise pattern to surface them.
3. For SharePoint Folder queries, open the Transform Sample File query and ensure that type changes are applied after combining, or enable Skip files with errors if some files do not match.
4. Clear the cache or refresh credentials if the issue persists.

Additionally, please refer to the links provided below:
Dealing with errors - Power Query | Microsoft Learn
Managing query refresh - Power BI | Microsoft Learn
Error handling - Power Query | Microsoft Learn
Combine files overview - Power Query | Microsoft Learn

We hope the information helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[tayloramy]

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. 

[mebiza]

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

[tayloramy]

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.