Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors