Forum Discussion

AndyUK's avatar
AndyUK
Regular Visitor
7 years ago
Solved

losing lines between Power Query and report

    I am pulling data from a simple, single table, odata feed that results in 84,869 rows in Power Query in PowerBI. I know the data source so I know this is the correct count. I also know that Pow...
Need Help
  • AndyUK's avatar
    AndyUK
    7 years ago

    Thanks for the reply.

     

    After more investigation this turned out to be a bug in the oData feed code that only mannifested itself when the data request was large and paging kicked in. It was paging of a non unique field. The Invoice ID, and each time an invoice happened to span a 5k page it would lose the lines from that invoice by starting the next page at the next invoice number.

     

    This made tracing the issue feel very random.

     

    Suffice to say it was not an issue with Power Query.

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi AndyUK

 

I cannot reproduce the same issue.The row count number in query editor is different from it in Data view,right?Are there any filters in data view?If it is not your case, please share the .pbix file for us to check. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie

 

AndyUK's avatar
AndyUK
Regular Visitor
7 years ago

Thanks for the reply.

 

After more investigation this turned out to be a bug in the oData feed code that only mannifested itself when the data request was large and paging kicked in. It was paging of a non unique field. The Invoice ID, and each time an invoice happened to span a 5k page it would lose the lines from that invoice by starting the next page at the next invoice number.

 

This made tracing the issue feel very random.

 

Suffice to say it was not an issue with Power Query.