Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

  • lbendlin's avatar
    lbendlin
    4 years ago

    Add a transform step "Use first row as headers"

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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'

 

Loaded the data via 'Web'

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Add a transform step "Use first row as headers"

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you very much. 

     

    This worked.