Error in connecting Power BI to Fleet API

[tariqpervez]

I have a 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.

[tariqpervez]

Please find below zoomed snapshots

[Anonymous]

HI @tariqpervez,

Perhaps you can take a look at the following blog to change the function usage with 'relativepath' and 'query' options if helps:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

In addition, the error message seems to mention a property can't be set to null. I'd like to suggest you also add that with non-null double type default value to the query.

Regards,

Xiaoxin Sheng

[lbendlin]

the screenshots are too small to read. Show sample code where you supply the "TotalDistance"  parameter.