Missing data in data view

[AR_24]

I have loaded in a csv file from sharepoint and have been working on a report for a few weeks now. Today I published the report to the workspace and entered all my credentials for scheduled refresh. Tested the refresh and now there's two specific questions in my dataset that have gone missing which is impacting some of my measures. When I check the data in power query it's still there but it's not in data view.

[V-yubandi-msft]

Hi @AR_24 ,

We haven’t received a response from your end yet. Please let us know whether the issue has been resolved or if you’re still facing any difficulties. Feel free to reach out if you need further assistance.

Thank you.

[SamInogic · Accepted solution]

Hi,

As per your description, the columns are visible in Power Query but missing in Data view after publishing and refresh. This typically indicates a model-level issue rather than a data source issue.

Possible Causes & Fixes

1. Column Not Loaded to Model
   Even if the column exists in Power Query, it may not be loaded.

• Go to Power Query → right-click the column
• Ensure “Enable Load” is checked
• Click Close & Apply

1. Column Removed in Applied Steps
   Check if any step is removing or transforming the column:

• Review Applied Steps
• Look for steps like:
• Removed Columns
• Select Columns
• Edit or remove the step if needed
  
  2. Column Hidden in Model
  Sometimes columns are hidden (especially if used only for measures):

• Go to Model view / Data view
• Check if the column is hidden
• Unhide if required
  
  3. Data Type or Errors After Refresh
  If refresh introduces errors:

• Check for errors/nulls in that column
• Ensure correct data type
• Fix any transformation issues
  
  4. Schema Change from Source (CSV in SharePoint)
  If the CSV structure changed (column renamed, reordered, or missing temporarily):

• Power BI may not map it correctly during refresh
• Reopen Power Query and refresh preview
• Reapply steps if needed
  
  5. Incremental / Partial Load Issue (Less Common)
  If using advanced refresh setups, some columns may not load properly after publish.
  
  

Quick Validation

• Compare Desktop vs Service after refresh
• Try:
• Refresh in Desktop → Publish again
• Or Download PBIX from Service (if possible) and compare

Hope this helps.

Thanks

[V-yubandi-msft]

Hi @AR_24 ,

Just following up hope @MasonMA  response was helpful. Let me know if you need any more information or clarification.

Thank you for your responses @MasonMA , @grazitti_sapna , @parry2k. 

[grazitti_sapna]

Hi @AR_24,

Please check below steps to indentify missing columns/data:-

1. Look in apply steps that

• Filtered Rows
• Removed Blank Rows
• Changed Type
• Removed Errors

2. Check if there's any datatype mismatched/changed

• Text changed to Number
• Or nulls introduced in base data (Check Remove nulls/errors steps)

3. Relationship logic changed

• In model view check for Active relationships
• Bi-directional relationships

4. look for hidden columns from fields pane 

5. Duplicate or changed name with a space like "space" and "space " can break the calculation

6. Ensure data load for the table is enabled in Power Query - right click and enable table load

If nothing works, delete the Older table and try to create with a new fresh table with same name so no calculation breaks.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[MasonMA]

Please share more details such as the Applied Steps or Advanced Editor (M code) for the query, the exact names of the missing columns, the Source step showing how the CSV is loaded etc..

[parry2k]

@AR_24 can you refresh the preview in the power query to make sure it is not showing from cache?