Excel Table updating

[BrendanElliott]

I created a Report based on an excel table in OneDrive for Business, I have since realised I had an error in my Excel table and corrected it, however I now need the fields to update and reflect the corrected table. I have searched and searched and cannot figure this out. Any suggestions or advice?

[Anonymous · Accepted solution]

If you are in Power BI Desktop, you simply need to press the "Refresh" in the ribbon.

If you are in the Power BI Service, you need to do a "Refresh Now" on the dataset.  Since you are connected to a file in One-Drive you might need to just make sure that you have all the credentials set up in the service.  You can do this from inside the Dataset settings under the area for Schedule Refresh.  These credentials will work for both manual and scheduled refreshes.