Need help

[Mohammed223]

 

When I want to refresh the data I got an error I don't know why!!!!

[PijushRoy]

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

[Daniel29195 · Accepted solution]

@Mohammed223 

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