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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors