Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Can someone help us to figure out the actual problem behind this?
Solved! Go to Solution.
Hi @hpoyil ,
See if this blog is helpful:
Refresh failure on Power BI Service for Jira Datasource
Best Regards,
Winniz
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.
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:
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