Hi @byzmjv
It is intended that the default fields for the Exchange connector in Power BI will only display the organizer's name rather than the event name when retrieving calendar data. To display the event name or subject in your own visual, there are a couple workarounds you can try:
Edit the query: The event name or subject can be added to the query using the Power Query Editor. Here is how to go about it:
To use the Power Query Editor in Power BI Desktop, select "Edit Queries" from the menu.
Find the query that uses the Exchange connector to retrieve the data from your calendar.
To include the subject field from the calendar data, expand or modify the query.
Click "Close & Apply" to save the changes and load the updated data into your report after adding the subject field.
Use a calculated column: To extract the event name or subject from the existing data in Power BI if changing the query is not an option, is a calculated column. Here is an illustration of a DAX formula used to construct a calculated column:
Navigate to the "Data" or "Fields" tab in Power BI Desktop.
Select "New Column" by performing a right-click on the table containing the calendar data.
Enter a formula like EventName = RELATED('Table'[Subject]) where 'Table' is the name of the real table and 'Subject' is the name of the relevant column.
To use the calculated column, simply click outside the formula bar.
Remember to save your changes and refresh the data in Power BI after applying any of these solutions to see the updated results in your report.
Thank You. Hope this will help you.
