cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors