Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

JSON error when connecting to Zendesk

I am getting the following error when trying to connect to Zendesk through the PowerBI app.  Details are as follows:

 

 

Data source type
Processing errorWe found extra characters at the end of JSON input.
Correlation ID4187d1c5-2302-09f2-382f-115bedb7623c
Activity IDaa19f917-5b4b-46fb-8db3-02467850e225
Request ID0f70bb30-1946-19e4-0c7e-540baa2098a5
Status code400
TimeTue Jun 27 2017 09:31:22 GMT-0500 (Central Daylight Time)
Version13.0.1721.165
Cluster URIhttps://wabi-us-north-central-b-redirect.analysis.windows.net

 

We are using SSO for Zendesk authentication.  I am not sure if the is contributing to the issue.

 

 

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @panagakis,

 

Based on my test, we are able to get data from Zendesk content pack use OAuth2 authentication. Make sure you are using Zendesk administrator account as suggested in this article: Zendesk content pack for Power BI.

 

Besides, you can download this .pbit file here to see if the issue related to Power BI service.

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support

Hi @panagakis,

 

Based on my test, we are able to get data from Zendesk content pack. In your scenario, make sure you are using the Zendesk Admin account as suggested in this article: Zendesk content pack for Power BI.

 

Besides, please download this .pbit file here to see if the issue related to Power BI service.

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
panagakis
New Member

I confirmed that the user account I am using is an administrator.

 

I downloaded the .pbit file and got the same error.

 

Please see the screenshot below.

 

Capture.PNG

 

Any further assistance would be appreciated.

 

Pete

panagakis
New Member

I figured it out.

 

I was using this URL to connect to Zendesk:

 

https://1boc.zendesk.com/agent/dashboard

 

I should have used this URL:

 

https://1boc.zendesk.com/

 

The funny thing is that it still allowed me to authenticate even though the URL was wrong.

 

Thanks for your help.