Skip to main content

Data Connector - HTTP request error 403

MLire-2077
Original Poster

Hi,

 

In PowerBi I want to import all my data starting at january 1st 2023. Using this path :

https://data-connector-1.geotab.com/odata/v4/svc/VehicleKpi_Daily?$search=from_2023-01-01_to_2025-08-31

 

I am getting the 416 error in PowerBi.

Capture d’écran 2025-08-22 114318 

Which I know means that the request for data is too large, and exceeds the limits for the Data Connector.

 

 

 

So I am trying a bypass method using a power automate flow. But I need to make work a GET call to OData.

 

I am testing in Postman :

Capture d’écran 2025-08-22 115101 

I am getting the error 403 forbidden, the server understood your request but refuses to fulfill it because you don't have permission to access the requested resource. Do you know a way to make that work please?

 

Thank you very much.

Join the conversation

You need to be logged in to reply to this post and participate in the Geotab Community discussions.

Top Answers

Can you use this URL and add your date filter to this instead of the one you are using?

https://odata-connector-ca-1.geotab.com/odata/v4/svc/

 

6 Replies

Hi,

 

Source: this document.

 

Postman, by default, strips the Authorization header when it follows a redirect to a different host. This is a security feature designed to prevent your sensitive credentials from being sent to an untrusted third-party server.

 

When a server responds with a redirect status code (like a 301 or 302), it's telling the client to make a new request to a different URL. For security reasons, Postman won't automatically include the Authorization header in this subsequent request, especially if the new URL is on a different domain. The new, unauthenticated request then fails, resulting in an error code like 400 Bad Request or 403 Forbidden.

 

To fix this, you need to manually add the Authorization header to the request. Instead of relying on the built-in "Authorization" tab, you should go to the Headers tab and explicitly create a new header with the key Authorization and its corresponding value. This ensures the header is included in every part of the request, even after a redirect.

MLire-2077
Original Poster

Thanks for your time.

 

I tried adding the autorization to the header but got no luck.

 

Capture d’écran 2025-08-26 111646And also tried to directly encode Base64

Capture d’écran 2025-08-26 100349 

I also tried in Python but it seems like I am missing a certificate verification.

 

Capture d’écran 2025-08-26 114642

Can you use this URL and add your date filter to this instead of the one you are using?

https://odata-connector-ca-1.geotab.com/odata/v4/svc/

 

MLire-2077
Original Poster

It worked!

 

Thank you very much Sajad. 😀

Excellent thank you for your patience. Yeah turns out that Postman can't handle the URL redirect. Tableau is similar so if you're interested the URL can be found under the Tableau tab in the Data Connector page in MyG.

GDC pic

Still have questions?