cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Updates not reflected in power bi desktop after updating excel in one drive

Hi Everyone,

 

I have an excel data stored on OneDrive share to others for editing as a source for my power Bi desktop, may i ask why does the updates from the excel file not reflected in the power bi desktop table section? (Example: Updated a new july row in excel, but power bi desktop still shows June.)

 

Thanks and Regards,

Zhide

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi Rena,

 

My report does update the new rows now, i think previously was because i didnt set the excel data formatted as a table. Now it does. Do i really have to format it then it will work? i have not change any settings yet.

 

Thanks and Regards,

VanCe

View solution in original post

13 REPLIES 13
Highlighted
Super User III
Super User III

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi @vance ,

 

You can refer these files for getting Data from Excel and Refresh Data.

 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

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

 

Highlighted
Helper I
Helper I

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi @vance ,

 

Did you refresh your report after data updates?

 

Regards

Highlighted
Super User IV
Super User IV

Re: Updates not reflected in power bi desktop after updating excel in one drive

@vance , one drive is not considered as a direct data source. So you have to refresh it. For power BI service schedule a refresh.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper III
Helper III

Re: Updates not reflected in power bi desktop after updating excel in one drive

yeah i did, clicked on the refresh button above. i even tried reupload the file to onedrive but to no avail. Unless i set the data source in excel as table format.

Highlighted
Helper III
Helper III

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hmm, but what if im not using the web service, like im using the Power Bi Desktop client, wanted it to reflect before i publish it to the service.

Highlighted
Helper III
Helper III

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi, i tried the web link method as well, its still the same. 🙁

Highlighted
Helper I
Helper I

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi @vance ,

If refresh does not work, I would try the things below.

1. Ensure the link/path of the source file is correct.

2. Edit Permissions and enter credentials that have access to the source file.

Melvlee_0-1594704937674.png

3. Hit Refresh button again.

 

Let me know how you go please.

 

Regards

 

Highlighted
Helper III
Helper III

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi Melvlee,

 

I checked the source path it correct, and i tried setting it to organization and public then i did a refresh but it shows me the error msg

 

The key didn't match any rows in the table.

 

i saved and restarted the file but its the same.

 

Thanks and Regards,

VanCe

Highlighted
Helper I
Helper I

Re: Updates not reflected in power bi desktop after updating excel in one drive

Hi @vance ,

 

Please refer to https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...

 

You will have to find what's missing and fix your power query. You are getting somewhere. Good luck.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors