cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BrendanElliott New Member
New Member

Excel Table updating

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Excel Table updating

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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


1 REPLY 1
Super User
Super User

Re: Excel Table updating

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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!