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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
greggcampa
New Member

Can't refresh a Data Set from Excel file

Brand new to Power BI!  I hope someone can help with my newbie question.  I have excel files stored on a network drive that I used to create a report and dashboard.  Is there a way to link directly to the network files so that everytime they are updated, my report and dashboard update automatically or do I have to connect to the excel file and load them everytime?

 

Any input is appreciated.

 

Gregg

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

Hi @greggcampa,

You can also install and configure Power BI on-premises gateway, then add Excel data source under on-premises gateway and use the gateway to refresh your dataset. For more detailed steps about how to add Excel data source under gateway, please check my reply in this similar thread: https://community.powerbi.com/t5/Integrations-with-Files-and/Scheduled-refresh-for-excel-file-with-o... .

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DQ
Frequent Visitor

If you want the Powerbi Dashboard in the Cloud do stay updated based on your Excel file . You will need to download and install the  personal gateway on your machine and setup the excel file as a data source. Then you can schedule refreshed. May require powebi pro version that has a 60 day free trial.

 

https://powerbi.microsoft.com/en-us/gateway/

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors