Forum Discussion

Cesylyaa's avatar
Cesylyaa
Icon for Helper I rankHelper I
2 years ago
Solved

Power 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...
Need Help
Show and Tell
Tutorial Requests
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    Did you add a new row with a different data type from their column? Usually those errors are due data type mismatches.

Cesylyaa's avatar
Cesylyaa
Icon for Helper I rankHelper I
2 years ago

Rows 270 and 271 are parrt of the initial data. 
I added the data contained in row 272.



I don't see any differences in the Data types.

What else could it be please?

 

ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
1 year ago

Cesylyaa 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.