Forum Discussion

PowerBIRes's avatar
PowerBIRes
Regular Visitor
6 years ago

Power BI Report Server with sharepoint Online data source - schedule refresh fails

The power BI desktop works fine when connected to sharepoint online using organizational account  which is a microsft account. But during.  The  report gets refreshed successfully in  PBI desktop. Bu...
Power BI Report Server with sharepoint Online data source
Jon-Heide's avatar
Jon-Heide
Microsoft Employee
6 years ago

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 ListYesNo

No

 

juanrdteleko's avatar
juanrdteleko
New Member
5 years ago

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

  • Jon-Heide's avatar
    Jon-Heide
    Microsoft Employee
    5 years ago

    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.