topic Error in connecting Power BI to Fleet API in Developer

Error in connecting Power BI to Fleet API

tariqpervez — Wed, 16 Mar 2022 15:46:04 GMT

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.

Re: Error in connecting Power BI to Fleet API

lbendlin — Fri, 18 Mar 2022 00:01:01 GMT

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

Re: Error in connecting Power BI to Fleet API

tariqpervez — Fri, 18 Mar 2022 03:25:45 GMT

Please find below zoomed snapshots

Re: Error in connecting Power BI to Fleet API

Anonymous — Mon, 28 Mar 2022 05:50:23 GMT

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 And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)

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