cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CMPENALOSA Frequent Visitor
Frequent Visitor

Service now failed to update data source credential error

I'm using PowerBI to access Service Now to pull incidents data but I'm getting an error when configuring my credential upon login. 

 

 PowerBIServiceNowError.JPG

9 REPLIES 9
Highlighted
ashokpershad Frequent Visitor
Frequent Visitor

Re: Service now failed to update data source credential error

Even i faced same issue with one of my dataset.

CMPENALOSA Frequent Visitor
Frequent Visitor

Re: Service now failed to update data source credential error

This is my first time creating the connection and never created a data set for service now. It seems like a connection because the error displays quickly and seems not validating my account yet.

v-ljerr-msft Super Contributor
Super Contributor

Re: Service now failed to update data source credential error

Hi @CMPENALOSA,

 

According to this article, there're some system requirements to connect to Power BI content pack for ServiceNow incidents:

  • An account that can access yourorganization.service-now.com with Basic authentication (Single Sign-On is not supported in this version)
  • The account must have rest_service role and read access to incident table

If you're hitting a credential error during load, please review the access requirements above. If you have the correct permissions and are still hitting issues, please work with your ServiceNow admin to ensure you have any additional permissions that may be required for your custom instance.Smiley Happy

 

Regards

Ross73312 Super Contributor
Super Contributor

Re: Service now failed to update data source credential error

Does your business use Single Sign On (SSO)?  If so, we tried to use this ServiceNow plug-in as well and found that it wouldn't work because our organisation uses that.  We are hoping ServiceNow fixes that soon.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


CMPENALOSA Frequent Visitor
Frequent Visitor

Re: Service now failed to update data source credential error

Thanks for the replies.

 

Our organization uses SSO so it could be the reason. Was the workaround is to use the ServiceNow plug-in? How do I get or implement this plug-in?

Ross73312 Super Contributor
Super Contributor

Re: Service now failed to update data source credential error

We didn't find a work around so we didn't progress.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


v-ljerr-msft Super Contributor
Super Contributor

Re: Service now failed to update data source credential error

Hi @CMPENALOSA@Ross73312,

 

To add support of Single Sign On (SSO) for connection to ServiceNow, I would suggest you submit your requirements on Power BI Ideas and vote it up. Here is similar idea for your reference.Smiley Happy

 

Regards

sravuri Visitor
Visitor

Re: Service now failed to update data source credential error

Even we are also facing the same issue, could you please anyone on helping this.

mnayar Established Member
Established Member

Re: Service now failed to update data source credential error

@v-ljerr-msft  We have both options for logging into Service Now. I am able to connect from Power BI Desktop to Service Now but not from Service. I found the issue is that our ServiceNow setup has a set of IP's its whitelisting. But Power BI does not have an IP Range we can whitelist. The Azure IP Ranges are in CIDR Format which is not supported by Service Now. 

 

Would a gateway be of use to resolve this issue? Any assistance on the same would be useful.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 393 members 3,717 guests
Please welcome our newest community members: