Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Data from SharePoint (Excel file) not updating in power query

Hi, 

 

I connected data from an excel file in SharePoint using the Web ('Get Data'). I do not have any queries or errors. 

I have read other threads. My refresh button in both desktop and power query are toggled to include enable content and include in background.

 

My data is still not updating when I refresh it to reflect the most updated SharePoint excle

sheet. How do I fix this?

2 ACCEPTED SOLUTIONS

For the web connector you need to take care of the refreshes yourself, it is not automatic.  

Yes, you need to reload your data

If your Power Query produces the exact same result then there willbe no impact to your visuals.

View solution in original post

Add a transform step "Use first row as headers"

View solution in original post

10 REPLIES 10
KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @Anonymous ,

 

Which sign-in method did you select?

Please use organizational account. 

KT_Bsmart2gethe_0-1653181357003.png

Regards

KT

Anonymous
Not applicable

Thank you. 

 

I used this method. The problem still persisted. I have reloaded the data using SharePoint folder. 

Anonymous
Not applicable

Thank you. This link is very helpful.

Anonymous
Not applicable

Thank you. 

I had difficulties using the SharePoint connector so I used The Web connector. A few questions-

Does this mean the data will not update with the Web connection? 
Will I have to reload my data using the SharePoint? 
Will this interfere with my current visuals? 

For the web connector you need to take care of the refreshes yourself, it is not automatic.  

Yes, you need to reload your data

If your Power Query produces the exact same result then there willbe no impact to your visuals.

Anonymous
Not applicable

Thank you. 

 

I have reloaded the data using 'SharePoint Folder' as I will need the data to refresh automatically. 

 

I am not facing the issue of the coloumns not displaying names as it did when I loaded it via the 'Web' function. 

 

Please see comparinson below. I would like my coloumns to display the header names instead of Coloumn 1,2,3 etc. 

 

Loaded the data via 'SharePoint folder'

christianadaa_0-1653195569619.png

 

Loaded the data via 'Web'

christianadaa_1-1653195670085.png

 

 

Add a transform step "Use first row as headers"

Anonymous
Not applicable

Thank you very much. 

 

This worked. 

lbendlin
Super User
Super User

Recommendation is to use the Sharepoint folder connector. Microsoft states that changes are "usually" replicated within one hour. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.