Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I used this post to expand recurring events into my Power BI model - https://community.fabric.microsoft.com/t5/Desktop/Transforming-Exchange-server-data-with-recurring-a...
So I have them all listed, however the indivudual responses all default to the original recurring instance/master. If I marked 'tentative' on the first occurence, that shows for all occurences, regardless of the ones that were marked as 'accepted' or declined'. I'm needing to show a report on the # of these recurring meetings that were attended, so I need to get to the individual responses.
Any ideas?
Thanks in advance.
I followed the query from the link in my OP to expand out the recurring meetings. When it expands, it shows all the single occurances as 'tentative'. I responded tentative to the whole series and then respond 'accept' to the individual occurance that I attend.
Below is the sshot of the Feb 26th meeting accepted on my outlook.
In Power BI, it doesn't reflect this. It shows the response to the first occurance of the series which is 'tentative'.
I'm looking for a way to have Power BI show the instances of a recurring meetings acceptance accurately.
Thanks!
Please post some sample data.
Show what you have (A) and show what you want to get (B) . Explain the logic to get from A to B.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |