Share via

Power BI Refresh Completed with Warnings – Need Help Understanding Issue

Sai Kumar 45 Reputation points
2026-03-27T10:54:18.3133333+00:00

Hello Team,

I’m experiencing an issue in Microsoft Power BI where a dataset refresh shows as “Completed”, but it includes warnings.

The refresh does not fail, but I’m concerned about the impact of these warnings on data accuracy and report outputs.

Microsoft 365 and Office | Other

2 answers

Sort by: Most helpful
  1. Wienik Kruithof 0 Reputation points
    2026-04-03T11:47:29.3166667+00:00

    This seems to be related to a Power BI Service update around March 26 that started surfacing warnings for unused measures and calculated columns with DAX errors — even when the refresh itself succeeds. As @Marcos found, the warnings are valid but the frustrating part is that the refresh history doesn't tell you which measure or column is causing it.

    If you're on Fabric capacity (F-SKU or FT1 trial), you can use the XMLA endpoint to inspect measures and find broken references. For Pro/PPU workspaces that's not an option unfortunately.

    I've been building a monitoring tool called MetricSign (app.metricsign.com) that handles exactly this kind of detection: it checks your datasets every 5 minutes for refresh failures, schema changes, and — on XMLA-enabled workspaces — broken measures and missing column references. Each incident shows what specifically changed and links directly to the relevant settings page in Power BI.

    It's in pre-beta right now and I'm looking for a few people managing multiple semantic models to test it. Free access, happy to help debug these warnings if you want to try it.


  2. Q&A Assist
    2026-03-27T10:54:36.4+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    In Power BI, a refresh that shows Completed with warnings means the semantic model was refreshed and new data was loaded, but non-fatal issues occurred that can affect calculations or future refreshes.

    Key points about these warnings:

    1. Data is updated, but some results may be wrong or blank
      Power BI logs a warning when refresh succeeds but encounters issues such as:
      • DAX expressions referencing a column or table that no longer exists.
      • Measures calling an unrecognized function.
      • Data type mismatches between the source and the semantic model. In these cases, the refresh completes and data is imported, but affected measures or visuals can show errors or blank values.
    2. Gateway and capacity-related issues can also trigger warnings
      • An outdated data gateway version can cause warnings that the gateway might soon stop working.
      • Memory limit issues during refresh can also generate warnings, which may indicate the model is close to failing refresh in the future.
    3. How to see and monitor warnings
      • Open the semantic model settings in the Power BI service and check the Refresh history. Entries marked as Completed with a warning icon or message indicate these non-fatal issues.
      • It is recommended to periodically review refresh history to catch and fix warnings before they cause refresh failures or incorrect report results.
    4. XMLA and REST API behavior
      • If refresh is initiated via the public XMLA endpoint, warnings are not logged in the Power BI Refresh history, even if non-fatal issues occur. They appear only in the XMLA response.
      • If refresh is initiated via the Power BI REST APIs, warnings are logged in the refresh history, but the Datasets - Get Refresh History and Get Refresh Execution Details REST APIs do not include warnings in their responses.
    5. Recommended actions
      • Open Refresh history for the dataset and read the warning details.
      • Fix any DAX references to missing tables/columns or invalid functions.
      • Resolve data type mismatches in Power Query or the source.
      • Update the on-premises data gateway to the latest version if mentioned.
      • If memory-related warnings appear, consider optimizing the model (reducing columns, cardinality, or partitions) or adjusting capacity.

    Warnings do not stop the refresh, but they are a signal that some parts of the model or environment are misconfigured and can lead to incorrect or incomplete report results if not addressed.


    References:

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.