Forum Discussion

HBajaj01's avatar
HBajaj01
New Member
7 months ago
Solved

Power BI Refresh Failure – Missing Column Productive Percentage

Hello Everyone,
One of our scheduled Power BI refreshes is failing. Upon investigation, I found that the query is referencing a column named Productive Percentage, which does not exist in the current table schema. I confirmed this by opening the dataset in Power BI Desktop, where the column is missing.
This indicates a schema mismatch between the source database and the Power BI model. The refresh process cannot resolve the missing column, which is causing the failure.
This means the refresh is attempting to pull data from a field that is either missing, renamed, or not included in the current schema. As a result, the query cannot resolve the column reference, which leads to the refresh error.
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    7 months ago

    Hello HBajaj01,
    Thank you for posting your query in the Microsoft Fabric Community Forum.

    Please check the power query steps in the dataset/dataflow and identify where Productive Percentage is referenced. Either update the query to use the correct column name or remove the reference entirely. Once the query schema aligns with the source, the refresh should complete successfully.


    Best regards,
    Ganesh Singamshetty.

4 Replies

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    7 months ago

    Hello HBajaj01,
    Thank you for posting your query in the Microsoft Fabric Community Forum.

    Please check the power query steps in the dataset/dataflow and identify where Productive Percentage is referenced. Either update the query to use the correct column name or remove the reference entirely. Once the query schema aligns with the source, the refresh should complete successfully.


    Best regards,
    Ganesh Singamshetty.

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    7 months ago

    Hello HBajaj01,

    We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

    Thank you.

     

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    6 months ago

    Hello HBajaj01,

    Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

    Thank you.