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

Jira data scheduled refresh Web.Contents failed to get contents

We are getting following error some issues related in scheduled refresh(Power BI Pro subscription) fetching data from Jira to Power BI using Rest API. 

"Web.Contents failed to get contents from ***"

"RequestHasContent":"False","RequestHasHeaders":"False","RequestHasTimeout":"True","UseCache":"True","UseBuffer":"True","StatusCode":"BadRequest","StatusDescription":" ","Exception":"Exception:\r\nExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=****\r\nMessage: The remote server returned an error: (400) 

 

The errors mostly occur on a certain refresh, concerning a certain projects queries

 

We are

  • Able to fetch data to Power BI desktop
  • Able to publish the data successfully to Power BI service
  • Manual refresh from the Power BI service is working fine
  • The data size is not big(~8 mb)
  • The refreshes are scheduled so that the overall stress is low

Can someone help us to figure out the actual problem behind this?

 

 

1 ACCEPTED SOLUTION
v-kkf-msft
Community Support
Community Support

Hi @hpoyil ,

 

See if this blog is helpful:

Refresh failure on Power BI Service for Jira Datasource 

 

Best Regards,
Winniz

View solution in original post

7 REPLIES 7
v-kkf-msft
Community Support
Community Support

Hi @hpoyil ,

 

The JIRA content pack for Power BI helps you quickly import JIRA data, and you will be asked to provide your JIRA URL and credentials. Once the connection has completed, Power BI will automatically create an out-of-the-box dashboard, report, and dataset with data from JIRA.

 

https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/ 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

Hi, we are able to successfully fetch the data from Jira and make reports.

As you can see in the question, we are facing issue in the scheduled refresh in Power BI service. 

v-kkf-msft
Community Support
Community Support

Hi @hpoyil ,

 

When a published dataset is refreshed, Power BI does some static analysis on the code to determine what the data sources for the dataset are and whether the supplied credentials are correct. In this case, the data source is a call to Web.Contents( ) then Power BI only checks the base url passed into the first parameter during static analysis.

 

If the definition of your data source depends on the parameters from a custom M function, that static analysis fails and therefore the dataset does not refresh. Try to use the RelativePath and Query options with Web.Contents( ) , leave the value passed to the first parameter as a static string.     

 

For example:

 

Web.Contents(
     "https://data.gov.uk/api/3/action/package_search?q=" 
     & Term
     )

 

Change to:

 

Web.Contents(
     "https://data.gov.uk/api/3/action/package_search", 
     [Query=[q=Term]]
     )

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

Hi, we are already giving the relative path.

As I mentioned in the question, we are able to manually refresh the data from Power BI service and the errors(please see in question) mostly occur on a certain refresh, concerning a certain projects queries. 

  • The data size is not big(~8 mb)
  • The refreshes are scheduled so that the overall stress is low

 

 

v-kkf-msft
Community Support
Community Support

Hi @hpoyil ,

 

400 error can be like malformed request syntax, invalid request parameters, or deceptive request routing etc.

 

Does you use Power BI Rest APIs to set schedule refresh? If so, you may have set your parameters incorrectly. Refer to the example code posted  here  and these documentation: 

Embed Token 

Datasets - Refresh Dataset In Group 

How to refresh Power BI dataset with REST API using SSIS 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

We have configured scheduled refresh from the Power BI service UI(Datasets > Scheduled Refresh).

 

As I mentioned, the refresh is working fine when we manually refresh(using "Refresh now" button) from the Power Bi service.  The errors(please see in question) mostly occur on a certain scheduled refresh, concerning a certain projects queries. 

 

 

Only on certain 

v-kkf-msft
Community Support
Community Support

Hi @hpoyil ,

 

See if this blog is helpful:

Refresh failure on Power BI Service for Jira Datasource 

 

Best Regards,
Winniz

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!