Office 365 calendar - missing data in Power BI service

[nbl]

Hi,

I've connected to my Office 365 account and can show all my calendar entries in Power BI desktop. But when I publish to the Power BI Service and refresh the data, some of the calendar entries are missing, and some change date.

Any ideas?

Thanks in advance.

[nickyvv]

Hi @nbl,

Are you using the Exchange Online connector in PBI Desktop?

It could have something to do that the Service is using UTC timezone to display content by default. You'll have to work around this in PBI Desktop for example by using DAX measures to solve this.

[nbl]

Hi @nickyvv 

No i'm using the "standard" Exchange connector and the same happens when I try the online one .

It works when I publish it, but then I do a "Refresh now" and some of the data goes missing or changes.