Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks it worked
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.