Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello All,
A little new to API calls. Would appreciate assistance.
The setup in the query statement below was working fine up until November 18th, 2020:
After which point it can no longer refresh due to the below error.
DataSource.Error: OData: The feed's metadata document appears to be invalid. Error: The metadata document could not be read from the message content.
UnexpectedXmlElement : The schema element 'NavigationProperty' was not expected in the given context. : (1, 376318)
Details:
DataSourceKind=OData
DataSourcePath=https://graph.microsoft.com/v1.0/$metadata
I'm wondering as to what I can do to resolve the error. I've investigated as best I can, but cannot seem to understand why it's happening.
The query statement is below, with confidential information redacted:
let
TokenUri = "https://login.microsoftonline.com/" & #"Azure Tenant Id" & "/oauth2/token",
ResourceId = "https://graph.microsoft.com",
TokenResponse = Json.Document(Web.Contents(TokenUri,
[
Content = Text.ToBinary(Uri.BuildQueryString([client_id = #"Azure Application Id", resource = ResourceId, grant_type = "client_credentials", client_secret = #"Azure Application Client Secret"])),
Headers = [Accept = "application/json"], ManualStatusHandling = {400}
]
)),
AzureAccessToken = TokenResponse[access_token],
Source = OData.Feed("https://graph.microsoft.com/v1.0/teams/12a3bc4d-ab56-12a3-1a23-123456ab7def/schedule", null, [Headers = [Authorization = "Bearer " & AzureAccessToken, Implementation="2.0", #"MS-APP-ACTS-AS" = "1234a567-12a3-1a23-1234-1ab2c345678d"]])
in
Source
Appreciate your assistance in advance!
Kind regards,
~Rice
I have the same problem:
some users I have an error and others do not
DataSource.NotFound: OData: Request failed (404): Error en el servidor remoto: (404) No se encontró. (Resource 'manager' does not exist or one of its queried reference-property objects are not present.)
Detalles:
DataSourceKind=OData
DataSourcePath=https://graph.windows.net/xxxxxxx.com.mx/directoryObjects/4fc95bc9-9efe-4645-8603-04213b6a9f9d/Micro...
Url=https://graph.windows.net/xxxxxxx.com.mx/directoryObjects/4fc95bc9-9efe-4645-8603-04213b6a9f9d/Micro...
I am facing the same issue as well, also since mid November.
Frustration = high.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |