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.
I'm importing a SharePoint Calendar into my PBI report. I've already fixed the issue of the timezones automatically going to UTC instead of the Central Time Zone the SharePoint calendar is set to. I'm now running into a problem that any of the calendar items that have a reoccuring setting automatically get an end date that is in the future, so it is just one long meeting on the calendar. This is because PBI brings in the end date in the future for any calandar invite that is reoccuring. See screenshots below.
I tried making a custom column to correct the end date, but when using that the reoccurence no longer shows up in my visual. Is there a way to fix this or am I going to have to tell my project team they can't use reoccuring meetings and have to enter them individually?
@jritchey I imagine that you have some sort of reoccurence flag or something? You are probably going to need to break out your reoccurring meetings, use something like GENERATESERIES to generate actual individual meetings and then append everything back together. Would be helpful if you shared complete data in text form so that this could be tested.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
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.