Forum Discussion
missing data in powerbi dataflow
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
😞
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.
3 Replies
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.
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.
