Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue when scheduling refresh using postman rest api public key

Hi,

  I just loaded a data in power bi dsktop using postman rest api as below in blank query 

actualUrl = "http://*******************?",
options = [Headers =[#"Content-type"="application/json",
#"Authorization"="***************"]],
result = Web.Contents(actualUrl, options)

In desktop, data loaded properly in anonymous connection. But in service it's showing Failed to update data source credentials. Why anonymous connection it's not working in service?

Can you please help me to resolve this

 

Thanks,

Krithika

Need Help

9 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    5 years ago

    Hi. Sometimes Power Bi Service needs more detail about the url. It needs to understand which part of the URL means what. That is why it is a good practise to split in the correct parameteres. Check this post out showing relative path and query path:

    https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

    This can help Power Bi to identify the source and credentials.

    Hope this helps,

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Eventhough it is not working. Data can be pulled in desktop and still in service can't able to refresh. It's showing refresh error as failed to update data source crendentials. since it's public key doesn't have credentials

      • ibarrau's avatar
        ibarrau
        Super User
        5 years ago

        Can you show the complete error message? In addition, please be sure to have the credentials configurated in the schedule refresh options like this:

         

        You can specify anonymous and sign in without anything else. This is an example of a dataset I have connected exactly like you.

        Regards,