Forum Discussion
Anonymous
6 years agoNot applicable
Data Source Credential Error - Freshdesk API - Power BI Service
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 se...
nickyvv
6 years agoMost Valuable Professional
Maybe you need to append the "/v2" to the data source instead of the RelativePath?
Anonymous
6 years agoNot applicable
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.
This seemed to get me past the Unsupported Function error but still had the authentication issue.
Any thoughts on this?
- nickyvv6 years agoMost Valuable ProfessionalHi 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. - tsmaswabela4 years agoNew Member
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.