Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
turkfoster
Frequent Visitor

Data refresh issue

‎08-05-2019 07:35 AM

Updating a SQL table with only 1.1m rows shows more than 6m records being refreshed during update. Its the only table where I have refresh turned on. What's going on?

Labels:
Message 1 of 8
1,121 Views
0
1 ACCEPTED SOLUTION
turkfoster
Frequent Visitor
In response to parry2k

‎08-05-2019 08:17 AM

The checksum is a good idea. I just want to be able to have confidence in the data that was loaded. Thanks!

View solution in original post

Message 7 of 8
1,094 Views
0
7 REPLIES 7
turkfoster
Frequent Visitor

‎08-05-2019 08:06 AM

The source table has 1.1m records but durning the refresh as its showing how many rows have been refreshed it goes way past 1.1m. I would have thought it could only show the number of records in the source table but its showing millions more. The good news is that it seems to have refreshed the table properly because when I look in table view after the refresh the number of records matches the source table so that's good.

Message 3 of 8
1,106 Views
0
parry2k
Super User
Super User
In response to turkfoster

‎08-05-2019 08:08 AM

@turkfoster ok so what is the issue than?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 4 of 8
1,103 Views
0
turkfoster
Frequent Visitor
In response to parry2k

‎08-05-2019 08:11 AM

It seems like there may not be an issue but it makes me nervouse that it is reflecting more rows in the refresh process than actually exist. As there are more than 1 m records in the result set I have to trust that they came through correctly but it seems odd to have the refresh showing upwards of 7m records being refreshed from a table that only has about 1m records.

Message 5 of 8
1,100 Views
0
parry2k
Super User
Super User
In response to turkfoster

‎08-05-2019 08:13 AM

@turkfoster without looking at it , it is very hrd to say what is going on.

 

after refersh, if row count matches with your source data then you are good. May be you check sum of few columns with sum on souce data to make sure value matches. 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 6 of 8
1,097 Views
0
turkfoster
Frequent Visitor
In response to parry2k

‎08-05-2019 08:17 AM

The checksum is a good idea. I just want to be able to have confidence in the data that was loaded. Thanks!

Message 7 of 8
1,095 Views
0
v-piga-msft
Resident Rockstar
Resident Rockstar
In response to turkfoster

‎08-12-2019 01:49 AM

Hi @turkfoster ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 8 of 8
1,085 Views
0
parry2k
Super User
Super User

‎08-05-2019 08:02 AM

@turkfoster what is the way you are checking that there are only 1.1m rows refreshed? 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 8
1,110 Views
0

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All