Forum Discussion

oberthou's avatar
oberthou
Frequent Visitor
9 years ago

Web Content source (servicenow) - Failed to update data source credentials

I' m new to publishing on powerbi. It's the first time I try.

 

My powerbi desktop file works well with a basic authentication to get date from a web content url (service-now.com) .

 

But once published on powerbi.com I get the following error message :

 

Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

 

 

 

Then I click on edit credentials and try to enter the login and password (BASIC authentication) like on powerbi desktop and get rejected with another error message  :

 

Failed to update data source credentials.

 

 

 

 

Can anyone help me ?
Thanks a lot.

 

Olivier

 

 

 

 

APIS and Embedding

7 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi oberthou,

     

    I'm not able to reproduce the issue on my side. Please try create a new report which uses the account I have registered to see if the same issue occurs.

     

     

    Best Regards,

    Qiuyun Yu

     

    • oberthou's avatar
      oberthou
      Frequent Visitor
      9 years ago

      I' m new to publishing on powerbi. It's the first time I try.

       

      My powerbi desktop file works well with a basic authentication to get date from a web content url (service-now.com) .

       

      But once published on powerbi.com I get the following error message :

       

      Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

       

       

       

      Then I click on edit credentials and try to enter the login and password (BASIC authentication) like on powerbi desktop and get rejected with another error message  :

       

      Failed to update data source credentials.

       

       

       

       

      Can anyone help me ?
      Thanks a lot.

       

      Olivier

       

       

       

       

  • oberthou's avatar
    oberthou
    Frequent Visitor
    9 years ago

    Hi Qiuyun Yu,

     

    Your dev instance seems to be offline.

    CAn you let me know when I can test again ?

     

    THanks.

     

     

     

     

     

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      Hi oberthou,

       

      The instance is waking up, please try to connect to it in desktop. I have changed the password, please use below credential:

       

      User: admin

      Password: Password01!

       

      Best Regards,
      Qiuyun Yu

      • oberthou's avatar
        oberthou
        Frequent Visitor
        9 years ago

        hi Qiuyun Yu,

         

        I just tried with areport pointing to your instance and I can authenticate with powerbi.com in your case indeed.

         

        The source is the same as for the one not working except the name of the instance (sgts is my case) :

         

        = Csv.Document(Web.Contents("https://dev24836.service-now.com/", [RelativePath="sc_task_list.do?sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate(%27"&Date_début_URL&"%27%2C%2700%3A00%3A00%27)%5EORu_closed_date%3E%3Djavascript%3Ags.dateGenerate(%27"&Date_début_URL&"%27%2C%27end%27)%5EORstateIN-5%2C1%2C2%5Eassignment_group%3Da36be95bf1a391007a68f46050f4658c&sysparm_first_row=1&sysparm_view=&CSV"]),[Delimiter=",", Encoding=28591])

         

        Any other idea ?

        Thanks.


        Olivier

  • antonstorozhuk's avatar
    antonstorozhuk
    Icon for Helper V rankHelper V
    3 years ago

    Hello oberthou 

    In case you're still struggling exporting data from Servicenow, you might want to try out our Servicenow app: Power BI Connector:

    We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at [email protected] if you need any assistance.

     

    Thank you.

    Regards,

    Anton

    ===

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.