Forum Discussion
SharePoint Sites Authentication as part of Web.Contents(_,[RelativePath=_])
Overcoming the challenge of Power BI Service preventing Dynamic Data Source refreshing, it would appear primolee had a very similar problem.
The solution mentioned there was to set up the source file paths as parameters.
This solution works, and only requires a small amount of maintenance on the report:
1. if the source files move to a different location, or change their name, the parameter for that file must be updated.
2. if a new source file is created, we can't rely on it being automagically added to the report. Instead, a new query must be created, with its own new parameter.
Therefore this solution works well for a small number of files on a large SharePoint drive.
Where my report previously took over an hour to refresh in Desktop, it now takes less than a minute, and the report is able to run scheduled refreshes on the service which are fully refreshed in under a minute also.
All in all this is a viable solution for my specific problem, but it would obviously be a large overhead for reports relying on many more data sources, or situations with a quickly growing number of data sources.
Overcoming the challenge of Power BI Service preventing Dynamic Data Source refreshing, it would appear primolee had a very similar problem.
The solution mentioned there was to set up the source file paths as parameters.
This solution works, and only requires a small amount of maintenance on the report:
1. if the source files move to a different location, or change their name, the parameter for that file must be updated.
2. if a new source file is created, we can't rely on it being automagically added to the report. Instead, a new query must be created, with its own new parameter.
Therefore this solution works well for a small number of files on a large SharePoint drive.
Where my report previously took over an hour to refresh in Desktop, it now takes less than a minute, and the report is able to run scheduled refreshes on the service which are fully refreshed in under a minute also.
All in all this is a viable solution for my specific problem, but it would obviously be a large overhead for reports relying on many more data sources, or situations with a quickly growing number of data sources.