Forum Discussion

mebiza's avatar
mebiza
Regular Visitor
11 months ago
Solved

Sharepoint Folder Query "Error"

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 continu...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    10 months ago

    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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
11 months ago

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.