cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vgt56gyr2
Frequent Visitor

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

😞

 

1 ACCEPTED SOLUTION
vgt56gyr2
Frequent Visitor

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.

View solution in original post

3 REPLIES 3
vgt56gyr2
Frequent Visitor

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
Frequent Visitor

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
Helper I
Helper I

@vgt56gyr2 

 

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

 

Thanks/Regards 

Kannan.N

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors