I have a PowerQuery Dataflow that has been functioning properly for months but was recently found to be missing records. To test, I copied the exact M script and ran it in PowerBI Desktop, finding all of the expected records returned.
I am puzzled that these return inconsistent results and hesitant to use Dataflows for this purpose, though it's a better solution long-term as this data source will be used in multiple models.
The query involves the steps below, with separate functions that retrieve auth tokens and paginated API results:
May I know whether you found records missing in Edit Queries page or a report page created on the dataflow? Have you ever refreshed this dataflow? Could you please check what kind of records missing from it and whether it is impacted by some filters you set?