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

[Anonymous]

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

[v-yueyunzh-msft]

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 · Accepted solution]

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.