Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
i try to retrieve data from ms graph and powerquery, i've a request like this :
let Calendar = (Account as text) as table=> let Source = OData.Feed("https://graphproxybi56lor.azurewebsites.net/v1.0/users/"&Account&"/calendarview?startdatetime="& Date.ToText(Date.AddMonths(DateTime.Date( DateTime.LocalNow() ),-6), "yyyy-MM-dd") &"T00:30:00.048Z&enddatetime="& Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyy-MM-dd") &"T23:30:00.048Z&$select=subject,start,end,categories",[Prefer = "outlook.timezone='Europe/Paris'"], [Implementation="2.0"]), Calendrier = Source in Calendrier in Calendar
the part [Prefer = "outlook.timezone='Europe/Paris'"] dont work, i always have UTC time zone , in graph explorer i've try and the request work , but i don't know how to pass arguments correctly in powerquery.
Thank for your help
Hi @mcorlou
Hi @mcorlou
If you connect to MS Graph API with Power BI Desktop, you could refer to these similar thread:
https://community.powerbi.com/t5/Desktop/Use-Microsoft-Graph-API-as-data-source/td-p/640426
https://docs.microsoft.com/en-us/power-query/samples/mygraph/readme
As the creator of that thread said below, it worked, could you check if it works for you?
I added the parameters in an extra file like:
{
"schedules": [
"room1@my.com",
"room1@my.com"
],
"startTime": {
"dateTime": "2019-03-01T09:00:00",
"timeZone": "Central European Time"
},
"endTime": {
"dateTime": "2019-04-01T09:00:00",
"timeZone": "Central European Time"
},
"availabilityViewInterval": "15"
}
And indeed, if I add this like:
source = Json.Document(Web.Contents(url,[ Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(params) ] ))
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.