Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Issue: Refresh failure on Power BI Service for Jira connected datasets
Error:
Error 1: -
Something went wrong.There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error:"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Web.Contents failed to get contents from 'https://jirad.aaaa.com/rest/api/2/search
(400): "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://jiradc2.ext.net.nokia.com/rest/api/2/search"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"
Cluster URI: WABI-XXX-redirect.analysis.windows.net
Activity ID: bxyz-1234-1234-8f25-fxxx
Request ID: abcd84-3333-a11a-12123-yyyy
Time: 2020-09-04 07:10:16Z
Error 2: -
When we do not use a Gateway, we get error: -
Something went wrong.There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: We found extra characters at the end of JSON input.. The exception was raised by the IDbCommand interface. Table: search.
Cluster URI: WABI-XXXX-redirect.analysis.windows.net
Activity ID: 5yyyy-92aa-4e82-af18-xxx
Request ID: czzzz-e4ww-3123-2123-axyz
Time: 2020-09-02 07:05:39Z
Cause:
Resolution: For this particular JIRA connection in this case, we made sure a Gateway is bound to the dataset. We used Basic Auth in PBI Desktop and Organizational privacy level. Same was updated on Power BI Service – Gateway settings.
Privacy Level in Power BI Desktop: -
File -> Options and Settings -> Options -> Privacy Level of Global Setting -> Combine data according to privacy of each data source -> File setting -> Combine data according to privacy of each data
Data source Settings -> Edit Permissions -> Choose Basic Auth -> OK -> Privacy Level -> choose Organizational Basic Auth used in Gateway settings: -
Summary:
Author: Srishti Sharma
Reviewer: Mounika Narayana Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.