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!

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

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. 

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

 

 

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 

Hi @hpoyil ,

 

See if this blog is helpful:

Refresh failure on Power BI Service for Jira Datasource 

 

Best Regards,
Winniz

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors