PowerBI Report doesn't Update - enters in an Everlasting Data Updating Mode

[joaomiguelf]

Hi.

My PowerBI Report enters in an Everlasting Data Updating Mode.
Like the symbol of loading/updating info statys always rotating, but it never ends.

Befor this issue, at least it showed some error or ended up with all sources successfully updated, in green.

Pictures below of presentation and status of Update.

Thanks so much for helping to solve this asap.

[joaomiguelf · Accepted solution]

Hello all.

I've just discovered that one of the excel files i'm loading went 16395 columns large because someone painted a line with red. 

So I had to unpaint the row in the excel, reduce the sheet to 30 columns.. and not it's ok for PowerBI to update it.