Power BI Exchange

1. Which OData version does the endpoint implement?
2. Are you using Fiddler to monitor the traffic?
   1. If so, what's the error response code returned by the endpoint for your use case?
   2. Are you capturing these error response codes in an Error.Record?
3. What headers are you passing to the endpoint?
4. Are you using the IncludeAnnotations and IncludeMetadataAnnotations options in the request?
   1. If so, what annotations terms are you providing?

If your OData endpoint uses v4, the specification states that error codes in the 4xx range indicate a client error, such as a malformed request, and that error codes in the 5xx range indicate service errors. My guess is that if a query requests data that is inaccessible due to permissions, then that would return error codes in the 5xx range.

Also, can you show the M functions you use to query the OData endpoint?

Lastly, there is a known issue with Power BI's implementation of OData v4 endpoints, which may not have anything to do with your question:
No Query Support for OData URLs

let
/* Errors */
    // define possible errors
    errors.badRequest = Record.AddField(Error.Record("Bad Request", "this dataset does not exist. It's most likely a misspelling in the value for 'vintage' or 'dataset'. Double check these values and make sure they're spelled correctly."), "Status", 404),
    errors.serviceUnavailable = Record.AddField(Error.Record("Service Unavailable", "the server is too busy right now and needs a short break. Don't worry, you can try again in a bit."), "Status", 503),
    // build an error table
    errors.table = Table.FromRecords({errors.badRequest, errors.serviceUnavailable}) meta [Reason = type text],

/* Variables */
    variables.url = "https://api.census.gov/data/2015/BADURL/variables.json",
    variables.response = 
        Web.Contents(
            variables.url,
            [
                ManualStatusHandling={404}
            ]
        ),
    variables.responseMetadata = Value.Metadata(variables.response),
    variables.responseCode = variables.responseMetadata[Response.Status],
    variables.responseHeaders = variables.responseMetadata[Headers],
    variables.json = if variables.responseCode <> 200 then error errors.table{List.PositionOf(errors.table[Status],variables.responseCode)} else Json.Document(variables.response)
in
    variables.json​

I hope this helps.

1. Which OData version does the endpoint implement?
2. Are you using Fiddler to monitor the traffic?
   1. If so, what's the error response code returned by the endpoint for your use case?
   2. Are you capturing these error response codes in an Error.Record?
3. What headers are you passing to the endpoint?
4. Are you using the IncludeAnnotations and IncludeMetadataAnnotations options in the request?
   1. If so, what annotations terms are you providing?

If your OData endpoint uses v4, the specification states that error codes in the 4xx range indicate a client error, such as a malformed request, and that error codes in the 5xx range indicate service errors. My guess is that if a query requests data that is inaccessible due to permissions, then that would return error codes in the 5xx range.

Also, can you show the M functions you use to query the OData endpoint?

Lastly, there is a known issue with Power BI's implementation of OData v4 endpoints, which may not have anything to do with your question:
No Query Support for OData URLs

let
/* Errors */
    // define possible errors
    errors.badRequest = Record.AddField(Error.Record("Bad Request", "this dataset does not exist. It's most likely a misspelling in the value for 'vintage' or 'dataset'. Double check these values and make sure they're spelled correctly."), "Status", 404),
    errors.serviceUnavailable = Record.AddField(Error.Record("Service Unavailable", "the server is too busy right now and needs a short break. Don't worry, you can try again in a bit."), "Status", 503),
    // build an error table
    errors.table = Table.FromRecords({errors.badRequest, errors.serviceUnavailable}) meta [Reason = type text],

/* Variables */
    variables.url = "https://api.census.gov/data/2015/BADURL/variables.json",
    variables.response = 
        Web.Contents(
            variables.url,
            [
                ManualStatusHandling={404}
            ]
        ),
    variables.responseMetadata = Value.Metadata(variables.response),
    variables.responseCode = variables.responseMetadata[Response.Status],
    variables.responseHeaders = variables.responseMetadata[Headers],
    variables.json = if variables.responseCode <> 200 then error errors.table{List.PositionOf(errors.table[Status],variables.responseCode)} else Json.Document(variables.response)
in
    variables.json​

I hope this helps.

1. Which OData version does the endpoint implement?
2. Are you using Fiddler to monitor the traffic?
   1. If so, what's the error response code returned by the endpoint for your use case?
   2. Are you capturing these error response codes in an Error.Record?
3. What headers are you passing to the endpoint?
4. Are you using the IncludeAnnotations and IncludeMetadataAnnotations options in the request?
   1. If so, what annotations terms are you providing?

If your OData endpoint uses v4, the specification states that error codes in the 4xx range indicate a client error, such as a malformed request, and that error codes in the 5xx range indicate service errors. My guess is that if a query requests data that is inaccessible due to permissions, then that would return error codes in the 5xx range.

Also, can you show the M functions you use to query the OData endpoint?

Lastly, there is a known issue with Power BI's implementation of OData v4 endpoints, which may not have anything to do with your question:
No Query Support for OData URLs

1. automatic query folding
2. schema detection
3. automatic data typing

1. automatic query folding
2. schema detection
3. automatic data typing