Forum Discussion
Power BI Report Server with sharepoint Online data source - schedule refresh fails
Correct, it's not supported. You can use a report with cached data (e.g. refresh inside PBI desktop). However, the server cannot authenticate with online as it only support windows/NTLM based connections.
Document notes: (cached, refresh, dq)
| SharePoint Online List | Yes | No | No |
are there any future plans to get this implemented in PBIRS?
If not what other alternatives are there to do automatic refresh through PBIRS for the sharepoint online list data sources?
Hi, Is this going to change? we have to refresh mannually in my organization as we cannot use the microsoft account credentials to schedule a refresh to the online PBI
Hi Juanrdteleko - it's not currently planned to support refreshing of online data soruces in PowerBI report server. If you are looking to access online sources, you should consider direct use of PowerBI.com.
Note there are 3rd party tools such as Power Update which can automate the refresh process for you with the on prem report server.
