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 UserCesylyaa check what Anonymous indicates. That's likely the issue as that column probably is typed as a numerical column. Click on the Changed Type step in Power Query and there change the Attribute Account to type Text. After that, you'll need to click on Insert/Replace step instead of adding a new one.
CesylyaaHelper I
Helper II had started off with the column having its contents in number format, and the other values i was adding were in currency format, hence the reason for the error.
Although they looked same, i had to check each value in the Data source to find out which ones were formatted wrongly.
Thank you!