Forum Discussion
Newbee data connection error 400 bad request
Morning all,
As a noob to the group I hope this is an ok ask.
I've got a copied version of a colleagues powerbi (desktop) dashboard and all works fine with the board i.e. interactive elements, interrogating the data etc...
however I can't seem to update the data (refresh the data).
The source is Jira and I have an active basic creds username and token that have been accepted but when i refresh i get a 400 bad request error.
Any ideas would be most appreciated... I have pasted the error and removed some of the query string in the atlassian url.
Error returned
Data source error: Web.Contents failed to get contents from 'https://eaflood.atlassian.net//rest/api/3/search?maxResults=100(removedURLComponents) (400): Bad Request. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: acb370a9-d345-4d86-889f-7b065b4ea329
Request ID: 5a4ca2db-1f13-8686-ed92-3a589100629c
Time: 2022-09-22 09:59:28Z
2 Replies
Hi @SPLR,
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]] )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
See if this blog is helpful:
Refresh failure on Power BI Service for Jira Datasource
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Has your problem been solved? If not, is there anything I can do to help you. If it has been solved, please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.