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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

External data in SharePoint Refresh Issue

Created excel file with 2 sheets of plain table data and 3 sheets with pivot table connecting to tabular model(external data connection). Developed Power Bi report off of this file and published in a workspace.  Right now I manually refresht he excel file and refresh Power BI and re-publish daily, is there a way to automate this refresh?

 

This file is saved in sharepoint site but need help to understand how this file can be refreshed automatically including the data refresh, so that power bi displays latest data.

 Please help

5 REPLIES 5
v-yiruan-msft
Community Support
Community Support

Hi @Anonymous ,

How did you connect the excel file in Sharepoint site and created the report in Power BI Desktop? Whether you use web connector with excel file from sharepoint online or other method? If you created the report based on Excel workbook on SharePoint Online, Power BI performs OneDrive refresh. OneDrive refresh synchronizes the report with their source files. By default, Power BI checks about every hour if a dataset connected to a file on SharePoint Online requires synchronization. You can check the details in the part "OneDrive refresh" of this documentation.

 

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank you, I used the analysis service connection in Excel.

Hi @Anonymous ,

Whether you connect the excel file in sharepoint using the method in below screenshot? 

Get data.JPG

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GilbertQ
Super User
Super User

Hi there

Yes this certainly can be done using the Power BI On-Premise Data Gateway

Here are details on how to get this done

https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thank you I will try this and keep you posted if it worked.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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