Dataflow Pre-load Outputs vs PowerBI-Accessed Outputs Differences

[Joey97]

Hi All,

I have been experiencing a weird behaviour with one of our dataflow recently.

We have a series of transformational steps that are applied to an Excel file.

Based on the output preview, we are expecting only 2 rows of data:

However, the outputs weren't what we expected when we connected to the dataflow. It seems like there were additional rows that arent meant to be there.

The funny thing is, that dataflow has been used for the past year with no issues.

Anyone able to shed some light?

[BA_Pete · Accepted solution]

Hi @Joey97 ,

Almost impossible to say without understanding what the Dataflow is actually doing, but my first thoughts would be either:

-1- Additional Excel files have been added to the folder that the Dataflow picks up files from.

-2- Additional data has been added to the Excel file by the source system.

-3- Additional sheets have been added to the Excel file.

For a more detailed evaluation, you'll need to provide more detailed information around what the source Excel file looks like, and exactly what transformations the Dataflow is performing.

Pete