Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

Hey Lin,

 

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

 

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago
    Maybe you need to append the "/v2" to the data source instead of the RelativePath?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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-bi/

       

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

       

      Any thoughts on this?

      • nickyvv's avatar
        nickyvv
        Most Valuable Professional
        6 years ago
        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.