Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data isn't refreshing from excel file on SharePoint unless enable content is clicked

Hello,

 

I am trying to refresh a Power BI Report using an excel file that is located on SharePoint. If I try to refresh, it doesn't give me any errors, but the data does not pull into the report. If I go into the excel file manually, click "Enable content" in the yellow ribbon at the top, then refresh in Power BI, it pulls the data properly.

 

I have tried to enable trust center settings in Excel for desktop for that specific SharePoint site, but it is still not refreshing as expected.

 

Does anyone know of a way to fix this issue? Any help is appreciated.

 

Thank you

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Aniya Zhang,

     

    Thank you for your reply! It doesn't look like this solved the problem. After doing some further digging, it looks like the excel file that I'm pulling from is using XLOOKUPS to pull from a separate excel file, and the workbook links section says that the separate file needs to be open in order to refresh. I've decided to connect straight to the source with Power Query to work around the issue.

     

    Thank you again.

2 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi,  Anonymous 

    According to your description, your data source is excel in sharepoint folder. No error was reported when you manually refreshed, but the data was not refreshed. My understanding is that this may be because your excel data is not synced.

    And you said that when you click "Enable Content" in your excel , it can get the newest data in dataset. For this , you can try to close the "Enable Content" feature in your excel.

     

    For more information, you can also refer to :
    What is enable content in Excel? – MassInitiative

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Aniya Zhang,

       

      Thank you for your reply! It doesn't look like this solved the problem. After doing some further digging, it looks like the excel file that I'm pulling from is using XLOOKUPS to pull from a separate excel file, and the workbook links section says that the separate file needs to be open in order to refresh. I've decided to connect straight to the source with Power Query to work around the issue.

       

      Thank you again.