Showing results for 
Search instead for 
Did you mean: 
Not applicable

error refreshing exchange online data source on the PBI report server

Hi, I'm having trouble refreshing Microsoft Exchange Online connection on the PBI reporting server. 

The connection is for a shared mailbox, i don't have any problem connecting to the mailbox from power bi destop. 

but when I "published" the report to the on-prem server, I getting an error connecting to the data source. 



In this case I'm using a shared mailbox in the connection string, and a service account mailbox (the shared mailbox is linked to) as a username for credentials. 




Any help or hints is very appreciated





Super User
Super User

Unfortunately Exchange Online is not supported for Scheduled Refresh operations. It's listed here as only supporting "Cached Data" which means you can refresh in Power BI Desktop and then upload to Report Server.


The only work around for this would be to write a script or process which could load the data from Exchange Online into a supported data source.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Kudoed Authors