Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Refreshing of Sharepoint Data

Hi,

 

I have an excel file loaded in from Sharepoint into my Power BI desktop, but it requires manual refreshing currently. I have a SQL server loaded in too and when i press 'refresh' at the top of the page it doesn't seem to refresh the fields I have created using the Sharepoint data. When I select 'incremental refresh' it says I need to set up parameters. Not sure what I need to put into the parameters, but for reference here are my Data Sources:

 

Thanks

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    In the new Sharepoint query, it has 4 steps to navigate to the correct sheet in the Excel file (the first 4 steps). In the old query, there are 2 steps to navigate to the sheet (the first two steps). So what you need to do is to copy the first 4 steps in the new Sharepoint query and insert these 4 steps into the old query before the 3rd step #"Removed Blank Rows" to replace original two steps. Don't forget to add a comma token at the end of the 4th step. As 4th step has the same name "Financial_Sheet" as the old query's 2nd step, you don't need to modify the referencing step in next step. Save the changes in Advanced Editor and the source will be replaced.

     

    Duplicate the old query in advance in case of losing any data. 

     

    Regards,

    Jing

8 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    What made you choose a web connector over a Sharepoint Folder connector?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Followed a tutorial on youtube, I copied the excel path and pasted into the web connector (I only need one file). Maybe I could change the source step in query editor and my data editing steps will still apply?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        5 years ago

        I would recommend you use the SharePoint folder connector instead. Might be more work upfront but gives you more flexibility overall.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

     

    Have you tried the SharePoint folder connector? Does it solve this problem?

     

    Best Regards,
    Community Support Team _ Jing

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi v-jingzhang, I am not too sure how to change the source in query editor such that I have applied steps from using the web connector and would ideally like to not start again with my web connected queries. After selecting new source and directing to the correct excel file in sharepoint, I have this as my advanced editor:

       

      And this is the advanced editor (steps) for one of the queries which I would like to change to the Sharepoint sourcing, thats currently web connected:

      How would I change the top sourcing format so that it includes the sharepoint connector? Thanks

       



      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous 

         

        In the new Sharepoint query, it has 4 steps to navigate to the correct sheet in the Excel file (the first 4 steps). In the old query, there are 2 steps to navigate to the sheet (the first two steps). So what you need to do is to copy the first 4 steps in the new Sharepoint query and insert these 4 steps into the old query before the 3rd step #"Removed Blank Rows" to replace original two steps. Don't forget to add a comma token at the end of the 4th step. As 4th step has the same name "Financial_Sheet" as the old query's 2nd step, you don't need to modify the referencing step in next step. Save the changes in Advanced Editor and the source will be replaced.

         

        Duplicate the old query in advance in case of losing any data. 

         

        Regards,

        Jing