Forum Discussion
Connection to outlook calender
Hi everyone,
I have a question about the connection to shared outlook calender. In my company, we would like to create an absence calendar with all employees, for which I should access the Outlook calendars.
I´ve done alle the settings like in this tutorial: Connecting to Shared Calendar in Power BI Desktop ... - Microsoft Fabric Community
But with this settings I get all calender appointsments included all private appointments with all the details.
Is there a solution where I don't get any private appointments, maybe via MS Admin Center? Or do anyone knows a smarter solution to get the calendar appointments?
Thanks!
Hi Robin_2024 ,
It sounds like you've successfully connected to the shared Outlook calendar in Power BI, but you're facing an issue with private appointments being included with full details. Unfortunately, Outlook’s default API permissions often allow access to all events unless filtered. A potential solution is configuring the Microsoft Graph API permissions to exclude private events or modifying the query in Power BI to filter them out. Another approach could be using Microsoft Admin Center to restrict what data is shared, possibly adjusting calendar sharing policies to ensure private appointments remain hidden.
2 Replies
rohit1991Super User
Hi Robin_2024 ,
It sounds like you've successfully connected to the shared Outlook calendar in Power BI, but you're facing an issue with private appointments being included with full details. Unfortunately, Outlook’s default API permissions often allow access to all events unless filtered. A potential solution is configuring the Microsoft Graph API permissions to exclude private events or modifying the query in Power BI to filter them out. Another approach could be using Microsoft Admin Center to restrict what data is shared, possibly adjusting calendar sharing policies to ensure private appointments remain hidden.
rohit1991 thanks!
I have now solved this by accessing the calendar entries via Microsoft Graph API. It worked wonderfully
