cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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. 

 

mikasmirnovs_0-1637534618744.png

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. 

 

mikasmirnovs_1-1637534726853.png

 

Any help or hints is very appreciated

 

Thanks, 

Mika

 

1 REPLY 1
d_gosbell
Super User
Super User

Unfortunately Exchange Online is not supported for Scheduled Refresh operations. It's listed here https://docs.microsoft.com/en-us/power-bi/report-server/data-sources 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

Announcements
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