Forum Discussion

dsullivan's avatar
dsullivan
Regular Visitor
9 years ago
Solved

Connection to Excel Table Stops Working

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 fo...
  • ankitpatira's avatar
    9 years ago

    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.