Connect to API. Bearer Token

Give this a shot.

The solution that continues to be missed, offered up by jayhawk and again by Mdauria6087 

Replace "3U2" with your token and you are on your way!

Hi jayhawk ,

Sorry, I don't know much about API. Hope these documents can help you:

Connecting Power BI with API;

Integration with Power BI.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, 

Your solution worked for me too (put "Authorization" as header parameter and then "Bearer [Bearer_key]" as value.

But how can i setup a daily update when i publish my report ? Where do i put the bearer token ?

I have a similar situation where I am trying to extract distance data of fleets through Fleet company's web API service. I am done with API authentication from where I got a ClientID, UserID & Token. Now using this information, I am trying to make  API calls from power bi. Below are the snapshots of steps which I followed; 

when the API call completes it shows null in data and an error

I have further expanded the error below. It says that "TotalDistance" property in "Distance" report cannot be set to a System.Decimal value it should be set to a non-null value of type System.Double

apart from this, I have tried making calls from their web API service portal and it runs fines and gives responses in JSON. Below is the snapshot of that 

Please provide your valuable feedback on this problem.

Does anyone know how to get a full YTD dataset from the Samsara API. The endCursor is limiting me to 3 rows only.

Here is my call:

GET /fleet/hos/daily-logs?startDate=2022-01-01&endDate=2022-11-01&driverActivationStatus=active&expand=vehicle HTTP/1.1
Accept: application/json
Authorization: Bearer samsara_api_?????????????????????????
Host: api.samsara.com

Did anyone figure out how to set up automatic refreshes on this data source? I have been able to pull the data from Samsara (thank you all for the above support), but when I publish online, I can't set up refreshes due to missing web credentials?

This is my M-Script call:

Json.Document(Web.Contents("https://api.samsara.com/fleet/vehicles", [Headers=[Authorization="Bearer myapiKey"]]))

and off of the vehicle id columns i call:

#"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each Json.Document(Web.Contents("https://api.samsara.com/",[RelativePath = "v1/fleet/trips" & "?startMs=" & Text.From(Duration.TotalSeconds(startMs - #datetime(1970, 1, 1, 0, 0, 0))) & "000" & "&endMs=" & Text.From(Duration.TotalSeconds(Date.From(DateTimeZone.LocalNow())-#date(1970, 1, 1))) & "000" & "&vehicleId=" & [data.id], Headers = [Authorization = "Bearer " & "myapiKey"]]))),

This solved it for me

You will need an API key for Samsara to use the BI web API access.

FYI:   Apparently, Samsara is working on a PowerBI Connector to be released sometime towards the end of 2023.