Forum Discussion

Daz4's avatar
Daz4
Helper I
4 years ago
Solved

Missing Rows when loading Dataflow into dataset

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 fro...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    Did you check column statistics (profile), any error in data that is skipping in the Viewing report?

levkalm's avatar
levkalm
Frequent Visitor
4 years ago

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!

  • Daz4's avatar
    Daz4
    Helper I
    4 years ago

    For me it was just a matter iof trying later. It just seemed toi fix itself in the end. 

    • levkalm's avatar
      levkalm
      Frequent Visitor
      4 years ago

      I could fix yesterday. Had to allow combining data from different sources.