Forum Discussion
Need help
When I want to refresh the data I got an error I don't know why!!!!
it seems like you have 308 rows having errors in the table that you have.
to find them,
go to power query,
you can see the rows with errors .
when a column have some errors , you can see under the column name the red line.
so you can check the reasons and try to fix them.
hope this helps you.
best regards
2 Replies
it seems like you have 308 rows having errors in the table that you have.
to find them,
go to power query,
you can see the rows with errors .
when a column have some errors , you can see under the column name the red line.
so you can check the reasons and try to fix them.
hope this helps you.
best regards
Hi Mohammed223
Please click on View Error, it will create a new table in power query with table name & error column.
Check the column which have error, also it will show you row number of the error rows.
Now follow the steps Daniel29195 mentioned in your main table (means your original table)
Rectify error and load again.
Please delete the auto-created table before load.
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
