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.
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.
Hi, I was being really stupid actually, gound my mistake.
Thank you for all your patience anyway and will accept your response as a solution as you've been trying to help 🤗