Column distribution not showing updated and correct number of rows

[akhaliq7]

I was originally getting a row count of 225 and then I updated the data in the source and tested there were 334 rows being returned and the id should be showing 334 in the distinct and unique sections within column distribution but this number still showing 225

What I tried:

I restarted power bi

I refreshed all and refreshed preview.

I pulled in the same sql view in a new query

After trying the above I still could not manage to get the right number to show in column distribution,

Any solutions/suggestions to this issue

[edhans · Accepted solution]

Clear your cache in Power Query. It is in the Data Load section of Options. This is from Excel, but Power BI's Power Query will be similar.