Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors