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 pu...
APIS and Embedding
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

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

    Hi oberthou,

     

    I guess the issue should be related to your account. Please contact ServiceNow admin to ensure you have any additional permissions that may be required for your custom instance.

     

    If issue persist, I would suggest you create a support ticket to get dedicated support.

     

    Best Regards,
    Qiuyun Yu