cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubham30us
Frequent Visitor

Auto/ Schedule Refresh for Excel based data source on report server.

Hi Guys, 

 

Wanted to check if there is any way by refersh the excel based data source reports on report server?

 

Currently we download the report first and then refersh the in Power Bi Desktop and then upload them again. 

 

Data source cant be migrated to sql due to some org/client restrication and policies.

 

@amitchandak @Fowmy @parry2k 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Shubham30us ,

 

Just as what @d_gosbell mentioned, if a File or Folder data source is used and the file path is a local path (e.g. C:\Users\user\Documents), then a refresh plan cannot be created. The path must be a path the report server can connect to like a network share. For example, \myshare\Documents.

 

For sharing a fileover a network in Windows 10, please refer: File sharing over a network in Windows 10 (microsoft.com). Then you can set scheduled refresh for reports.

share.PNGshare2.PNG

 

 

Best Regards,

Icey

 

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
Icey
Community Support
Community Support

Hi @Shubham30us ,

 

Just as what @d_gosbell mentioned, if a File or Folder data source is used and the file path is a local path (e.g. C:\Users\user\Documents), then a refresh plan cannot be created. The path must be a path the report server can connect to like a network share. For example, \myshare\Documents.

 

For sharing a fileover a network in Windows 10, please refer: File sharing over a network in Windows 10 (microsoft.com). Then you can set scheduled refresh for reports.

share.PNGshare2.PNG

 

 

Best Regards,

Icey

 

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

d_gosbell
Super User II
Super User II

Yes it is possible to schedule a report using a file based data source like Excel.

 

The only "trick" is that you have to put the file in a location that the server has access to like a network drive. And you have to use the UNC path (eg. \\server\share_name) not a mapped drive like G:\ . The reason for this is that drive mapping can be configured differently for each user and they are usually mapped when the user logs in to the desktop and the service account running PBIRS does not logon to an interactive session.

 

Once you've setup your file source with a UNC path in Power BI Desktop and re-published the report to the server the option to schedule a refresh should be enabled.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.