March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello everyone,
I'm trying to find the best solution to an unfortunate situation here:
We created a big report with BI Desktop using SharePoint lists as data source, everything is working fine and looking good so far.
Now we had to put it into production on our Report Server (because scheduled updates are exactly what we need) and for some strange reason it doesn't support the web version SharePoint lists (even though both products are from Microsoft)... How is this designed to be used in a situation like this?
If I try to connect through the Report Server I can only authenticate as "Anonymous" or with "Windows Login", but as we are dealing with data that only a group of people in the company have access to we need to be able to log in using some credential such as an e-mail that has permission to view this information.
Thanks.
Solved! Go to Solution.
So I hate to be the bearer of bad news, but Sharepoint Online is listed here as not supported for scheduled refresh. https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
You options are to either:
Thanks @d_gosbell for the answer.
Manually updating the report like "open the desktop version and click update" would probably not be enough, we're looking for something the user can open this report online and it just works.
I was wondering: would it be possible to use Power Automate to export the SharePoint lists as an Excel file (as .xls) and store it in OneDrive and then use Report Server to update the reports using those new files in OneDrive? Is there something I'm missing that might make this not work?
I can change the connections in BI to the new files without much problem, right?
Thanks!
@Gilmar-Neto wrote:
I was wondering: would it be possible to use Power Automate to export the SharePoint lists as an Excel file (as .xls) and store it in OneDrive and then use Report Server to update the reports using those new files in OneDrive? Is there something I'm missing that might make this not work?
Nope. It's not so much the data location that is the issue, its the AzureAD/OAuth2 authentication that is the problem. OneDrive uses the same authentication as Sharepoint Online so its not supported for scheduled refresh either.
So I hate to be the bearer of bad news, but Sharepoint Online is listed here as not supported for scheduled refresh. https://docs.microsoft.com/en-us/power-bi/report-server/data-sources
You options are to either:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
4 | |
3 |