Forum Discussion
Dataflow data loading in Semantic Model and Power Query but not Power BI tables/visuals
The data view is the second one.
Not sure what you mean by filtering the missing data since it's not missing from PQ and just from the visual tables -- Since the missing data are in pq, you can filter pq to just those rows and load only those to the model. If they don't show up there but are in the data view then as mentioned, check for hidden slicers and filters in the filter pane. You can add a clear all slicers button as well. Additionally, if you're using a measure that returns blank for some rows, they could be the culprit as by default, rows with blank values are not shown.
This usually happens if you recently modified the dataflow query. I would try refreshing the dataflow again or Power BI desktop. Or perhaps you've applied a filter in the desktop query and you forgot about it.
Hi danextian,
Like I said in my post, already checked all of that.
Thanks,
Ana
You said report view. How about in the table/data view? Are the missing data in there?
I would also try filtering pq to just the missing data and load it to the table and check if they're still missing. If they're still missing, check the filter panes or for hidden slicers.