missing data in powerbi dataflow

[vgt56gyr2]

Hi all,

one of the tables (could be others) in our dataflow is missing rows of data, used excel and powerbi, still not getting the correct amount of rows as per underlying sql query.  How do we troubleshoot and fix this? Doesn't give a lot of confidence to be using flows

😞

[vgt56gyr2]

we found out that there was stale/corrupt sharepoint excel credentials in our flows but the dataflow was not raising an exception, issue been reported to msft and hopefully they can fix.

[vgt56gyr2 · Accepted solution]

Hi,

It gives a false impression to the users that the dataflow has fully refreshed but because some tables had invalid credentials it assumed completion when in reality it was a partial load.

This was a bit tricky because some of the tables reported completed refreshes when in reality this was incorrect status, suggest users out there check their flows carefully while msft fixes this issue.

[Kannan_n]

@vgt56gyr2 

Can you give some example i can give you answer. Example file i can shocase 

Thanks/Regards 

Kannan.N