Connection to Excel Table Stops Working

[dsullivan]

I created an excel file that we want to allow users to look at reporting for through Power BI.  The excel file has a single table and is maintained by a person with whom I shared it to on Onedrive for business.

When I initially created the file it connected it to PowerBI it worked perfectly.  I tested changing the data, adding/removing rows fromt the table, etc.  Everything worked fine.  A few days later I went back to look and all the tiles had errors.  The first time I opened it, all 5 tiles were broken.  Now 4 of the tiles show (although as you can see the fields show errors) and just one is broken fully.

The error message is...

Something's wrong with one or more fields: (_Birchwood Acquisition Pipeline - Current) LAST STATUS, (_Birchwood Acquisition Pipeline - Current) Portfolio Name, (_Birchwood Acquisition Pipeline - Current) Purchase Price
Please try again later or contact support. If you contact support, please provide these details.

I've gone back to look at the file and it doesn't appear that any of the headers have been changed or that there is any invalid data in the table.  

What is going on here?  It seems like Power BI isn't ready for prime time yet to me.  

[aflores]

I did the same. Created an excel connected to my Power BI report. The problem I have is that for some columns, the numbers in the excel don't match. I have no clue on what is going on.

Any Ideas?

[ankitpatira · Accepted solution]

@dsullivan Most likely that error 'Something went wrong with one or more fields' means something has changed with metadata that has caused it to fail. Since you've got large number of fields I would suggest rather than figuring out what is wrong there in power bi service, open up pbix file for the report and do refresh there. It will throw error if it is unable to refresh and you can go to query editor to have more advanced look at what went wrong. 

In my opinion I have seen those type of errors (error sign instead of field name under Values section) when during refresh file isn't accessible ie moved to new folder or new tab or something like that.

[dsullivan]

I ended up just rebuilding the project, but next time this happens I'll try this.  Thanks!