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,
The report view I mentione in PBI, is the one below - where you create your visuals:
Like I said, I check all filters and queries everywhere: PQ/PBI/Dataflow.
Not sure what you mean by filtering the missing data since it's not missing from PQ and just from the visual tables (again, no filters at all). So for example, I if filter the records by User in PQ I can see more records (in the PQ table) than what I see on the visual table (on the report view). So there is no way I can filter the missing data since it's missing?!
Thanks,
Ana
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 🤗