Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Anonymous ,
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.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
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.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |