Newbee data connection error 400 bad request

[Anonymous]

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

[Anonymous]

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. 

[Anonymous]

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: 

Embed Token 

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.