Forum Discussion
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 started with, I can refresh my dashboards just fine.
When i now add new rows to the Google Sheets, and refresh in Power BI Desktop, i get an error.
Kindly Note that when i remove the added rows and refresh, it refreshes with no error.
The moment i add a new row, it shows that row as an error.
Please help.
Did you add a new row with a different data type from their column? Usually those errors are due data type mismatches.
9 Replies
- ray_aramburo
Super User
Did you add a new row with a different data type from their column? Usually those errors are due data type mismatches.
I went through the data again.
Indeed, it was a data type problem.
Although it looked the same, the underlying formatting was different.
Thank you so much.
CesylyaaI 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!- Cesylyaa
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
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.
- audreygerred
Hi! Have you clicked the view errors to see what is going on? Is there something different with the 1 new row compared to the rest?
- Cesylyaa
For the error, when i click on it, this is what ai see
