Forum Discussion

Helper I

1 year 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
1 year ago
Did you add a new row with a different data type from their column? Usually those errors are due data type mismatches.

Cesylyaa

Helper I

1 year 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?

Anonymous

Not applicable

1 year ago

Thanks for the reply from ray_aramburo and audreygerred , please allow me to provide another insight:

Hi, Cesylyaa

Could you please inform me about the data types of the Attributed Account and Remark columns in the Power Query process?

If the Attributed Account column has been converted to a numeric type after data processing, then given that your new data is "Unknown," which is a text type, it may not be possible to convert this text containing characters into a numeric type.