Forum Discussion
Error in connecting Power BI to Fleet API
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.
3 Replies
the screenshots are too small to read. Show sample code where you supply the "TotalDistance" parameter.
Please find below zoomed snapshots
HI tariqpervez,
Perhaps you can take a look at the following blog to change the function usage with 'relativepath' and 'query' options if helps:
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
