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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vilenm
Helper II
Helper II

Excel linked to on premise require schedule refresh

Hi

 

Is it possible to schedule a refresh for excel file on power bi service thats linked to a on prem tabular model?

The gateway permissions for power bi not sure if that must be applied for the excel file as well? can one do schedule refresh on it or can one use MS flow to assist?

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @vilenm ;

Do you mean you want to connect to excel .pbix file Set refresh schedule right? If so, then you can schedule a refresh directly.

 

Connecting to on-premises data sources(excel, You have the following options:

  • Choose an enterprise data gateway with the required data source definition
  • Deploy a personal data gateway

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @vilenm;

 

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yalanwu-msft
Community Support
Community Support

Hi, @vilenm ;

Do you mean you want to connect to excel .pbix file Set refresh schedule right? If so, then you can schedule a refresh directly.

 

Connecting to on-premises data sources(excel, You have the following options:

  • Choose an enterprise data gateway with the required data source definition
  • Deploy a personal data gateway

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors