Data Source Credential Error - Freshdesk API - Power BI Service

[Anonymous]

We have a PBI report that is connected to the Freshdesk API and uses Basic Authentication.  The report works great when refreshing locally from PBI desktop; however, we get an error when trying to set up the Data Source Credentials in the Power BI Service.

Here is a snippet from the PBI desktop file that is refreshing properly:

The function that pulls from the API is using RelativePath and populating default parameters for the call.

Any help on resolving this error would be greatly appreciated!!!!

[v-lili6-msft]

hi @Anonymous 

You may try to clear all permissions in "Data Source Settings" in Power Query Editor in Power BI Desktop app and then setting them again and publishing to the cloud refreshed requests done by Power BI Cloud.

Regards,

Lin

[Anonymous]

Hey Lin,

Thanks for the suggestion.  Unfortunately when I clear the permissions I still the error below in PBI Service:

[nickyvv]

Maybe you need to append the "/v2" to the data source instead of the RelativePath?

[Anonymous]

Hey @nickyvv ,

I've added the complete url back in and removed the RelativePath.  Here's what the M looks like now:

This here is the error I get now:

Here's an article from Chris Webb's blog on adding in RelativePath to get past the refresh issue.

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...

This seemed to get me past the Unsupported Function error but still had the authentication issue.

Any thoughts on this?

[tsmaswabela]

Hey @Anonymous ,

I know this is an old post but you can try the attached query. It worked for me when I was facing a similar issue, I hope it works for you too.

[nickyvv]

Hi @Anonymous,

Sorry, I actually meant only adding the v2 to the Web.Contents function, so this:
https://xxx.freshdesk.com/api/v2
And leave the rest in the RelativePath to deal with the authentication as Chris mentions in his blog.