Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I wonder if anyone knows what mihgt be wrong in my data. I have a dataflow that i feed into a dataset and have no filters at all on the dataset. The issue I have is that there are 12 rows missing from the dataset that I can see in the Dataflow. I have tried a fresh dataset just to make sure there are no hidden filters, and have applied no steps other than filtering down to look for a specific row that I can see in my dataflow. I have updated successfully several times to make sure the data is up to date. The source data is fine of course also.
Any ideas anybody???
Solved! Go to Solution.
Did you check column statistics (profile), any error in data that is skipping in the Viewing report?
Proud to be a Super User!
Hi everyone,
I got exactly the same issue. So, eventually, how did you solve it? Just let it be and it fixed itself?
Thanks
Hi,
I have a similar issue. I have a Dataflow that does the transformation and I see all rows I need to in the specific table, however when I want to pull the table into PBI Desktop, many rows are missing. I tried to re-establish the credentials, didn't work. I tried to add the table again, didn't work. There are also no filters applied or errors there that would block me. What is strange is if I copy the M code from PBI Service to PBI Desktop, the results are same, however still when I connect to the Dataflow from Desktop and select the table, it will not pull in all rows.
Do you have any suggestion why is that? or what should i try solving this?
Thanks!
For me it was just a matter iof trying later. It just seemed toi fix itself in the end.
I could fix yesterday. Had to allow combining data from different sources.
Thanks I hadn't thought of that, but no errors there or anything else that springs out. I'm rather baffled!
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 ?
Proud to be a Super User!
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?
Proud to be a Super User!
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!!!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
79 | |
64 | |
62 | |
56 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |