Forum Discussion
Semantic model does not load all data from Dataflow Gen 1
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .If it is a consistent number of rows that makes me think that the issue is with the load and the rows are being errored out for some reason. That should be very evident in Transform data though. Any inconsistent number of rows would lead me in the direction of resource constraints.
IMO you are firmly in the open a ticket with Microsoft support arena.
Please mark this post as solution if it helps you. Appreciate Kudos.
I filter for spesific data rows and see that the same filter in the Dataflow (Spesific olumn | Begins with | Value) gives a different result that the same filter in Power BI Desktop (Drag column to canvas | advanced filtering | starts with | Value)
Regards
Jon Terje Tjønn
There is a row limit on the canvas visuals, although that shouldn’t really matter when you are specifically filtering it down.
However, I would step back and try and narrow down the problem and see if it is a consistent problem. Start with confirming what the row count should be and then check that against the row count on the table in your model to see if it is actually different. If it is then I would try to recreate the problem to see if I get to the same missing number of rows each time.
Next, I would go to Transform Data and check some column profiles and look for errors.
Please mark this post as solution if it helps you. Appreciate Kudos.
Sorry for not informing about this up front, but I checked row count. Aprox 40% of rows missing. That is quite a bit... I will check if it is consistently the same amount.
If the test shows consistent rows missing, is that indicating a spesific know issue or error?
Regards
Jon Terje
If it is a consistent number of rows that makes me think that the issue is with the load and the rows are being errored out for some reason. That should be very evident in Transform data though. Any inconsistent number of rows would lead me in the direction of resource constraints.
IMO you are firmly in the open a ticket with Microsoft support arena.
Please mark this post as solution if it helps you. Appreciate Kudos.
Yeah, a ticket will be the next step.
Thanks for your answer, Andrew.
Regards
Jon Terje