Forum Discussion
Cesylyaa
Helper I
Helper IPower BI Desktop does not refresh from Google Sheets, shows Error
I started analysis/visualization on Power BI Desktop, with my Data Source as Google Sheets. All was working fine, the data was being pulled successfully. While working with the file content i sta...
Did you add a new row with a different data type from their column? Usually those errors are due data type mismatches.
ray_aramburo
Super User
Super UserDid you add a new row with a different data type from their column? Usually those errors are due data type mismatches.
CesylyaaHelper I
Helper II went through the data again.
Indeed, it was a data type issue.
Although the numeric data looked same, they were formatted differently.
One was currency and the other was Number format.
I've resolved it.
Thank you!