Forum Discussion
Missing Rows when loading Dataflow into dataset
Did you check column statistics (profile), any error in data that is skipping in the Viewing report?
Do you have any filters applied at the report level?
Do you have any RLS applied on your report that is limiting the data?
Is your data missing at Desktop or at PBI Service ?
There is a filter but it is the same on both Dataflow and Dataset. I have even tried replicating a new Dataset without any filters and the rows still do not appear.
It seems fine at Service level but missing from Power BI desktop as well as the service level dataset.
No RLS that I have applied, and the missing rows do not seem to have any RLS type rule applicable. For example, on a specific date I have agent x taking 10 calls and a random one of them doesnt show up. I can see the other 9.
Did you check column statistics (profile), any error in data that is skipping in the Viewing report?
I hadnt thought of that so thanks for the suggestion. I just tried and nothing there.
However, I just looked again and the data just appeared for no reason! Maybe something along the way, but I have no idea still what caused the issue. Possibly just a bug???
Any way I greatly appreciated your suggestiosn Farhan!!!