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. 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 : 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.

Data Connector - HTTP request error 403

page-user page-user-mathieu-lirette-2077 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

It worked! Thank you very much Sajad. 😀

Thanks for your time. I tried adding the autorization to the header but got no luck. <img src="/forum/plugins/gcs-uploads/files/069Pd00000XZUjXIAX.png" alt="Capture d’écran 2025-08-26 111646" />And also tried to directly encode Base64<img src="/forum/plugins/gcs-uploads/files/069Pd00000Xa4oTIAR.png" alt="Capture d’écran 2025-08-26 100349" /> I also tried in Python but it seems like I am missing a certificate verification. <img src="/forum/plugins/gcs-uploads/files/069Pd00000XZ53aIAD.png" alt="Capture d’écran 2025-08-26 114642" />

Hi, In PowerBi I want to import all my data starting at january 1st 2023. Using this path :	<a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdata-connector-1.geotab.com%2Fodata%2Fv4%2Fsvc%2FVehicleKpi_Daily%3F%24search%3Dfrom_2023-01-01_to_2025-08-31&amp;data=05%7C02%7Cmathieu.lirette%40avantis.coop%7C910550e2be4e46953c7c08dde21f50a0%7Ce9c51d87f7f940a3830be8f62291380a%7C1%7C0%7C638915346349961903%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=vwDTwEOE1y9koNK%2BbCTVgGP%2Bs7da8V3Ki0AxRmwbcYo%3D&amp;reserved=0" target="_blank">https://data-connector-1.geotab.com/odata/v4/svc/VehicleKpi_Daily?$search=from_2023-01-01_to_2025-08-31</a> I am getting the 416 error in PowerBi.<img src="/forum/plugins/gcs-uploads/files/069Pd00000XPGZgIAP.png" alt="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 :<img src="/forum/plugins/gcs-uploads/files/069Pd00000XPBP8IAP.png" alt="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.

Viimeaikaiset toiminnot

Data Connector - HTTP request error 403