Unable to get data from rest API error 409 conflict

[BI_Analyticz]

Hi friends,

Some APIs are giving successful data in power bi desktop but some are not. 

Example the below API call is giving me data in CURL / Powershell. But when tried in Power BI desktop from the same machine it is giving me error as 409 conflict.

curl -H "X-Requested-With: Curl Sample" -u "xxxxxxxxxxxxxxxxxxxxxxxxxxx" "https://qualysapi.qualys.eu/api/2.0/fo/qid/search_list/dynamic/?action=list" >C:\PBIITO_Datasource\DynamicSearchList.xml

I dont know why I am getting the error.

[v-kelly-msft]

Hi  @BI_Analyticz ,

Try below method:

For details,check below reference :

https://alexdmeyer.com/2020/06/16/how-to-configure-power-bi-to-utilize-a-custom-api-as-a-data-source...

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

[BI_Analyticz]

Below is my query. I managed to see / preview the data but Power BI is sending 3 concurrent calls for the same API to the source. Do to this the data refresh is failing.

When I try the API call from CURL or anyother means then it is sending one call request. But Power BI is sending 3 call requests.

let
Source = Xml.Tables(Web.Contents("https://qualysapi.qualys.eu/api/2.0/fo/knowledge_base/vuln/?action=list&details=All", [Headers=[Authorization="Basic XXXXXXXXXXXXXXXXX", #"X-Requested-With"="Detection"]])),
Table0 = Source{0}[Table],
VULN_LIST = Table0{0}[VULN_LIST],
VULN = VULN_LIST{0}[VULN],
#"Changed Type" = Table.TransformColumnTypes(VULN,{{"QID", Int64.Type}, {"VULN_TYPE", type text}, {"SEVERITY_LEVEL", Int64.Type}, {"TITLE", type text}, {"CATEGORY", type text}, {"LAST_SERVICE_MODIFICATION_DATETIME", type datetime}, {"PUBLISHED_DATETIME", type datetime}, {"PATCHABLE", Int64.Type}, {"DIAGNOSIS", type text}, {"PCI_FLAG", Int64.Type}, {"CONSEQUENCE", type text}, {"SOLUTION", type text}})

in
#"Changed Type"

[v-kelly-msft]

Hi  @BI_Analyticz ,

Sorry for the late reply.

For 409 error:

409 Conflict

Returned when write operations conflict. This error is returned for resource updates, or during indexing when two processes try to update the same document simultaneously. Azure Cognitive Search provides concurrency management for resource updates. For more information, see How to manage concurrency in Azure Cognitive Search.

Pls check whether below codes work:

let
Source = Xml.Tables(Web.Contents("https://qualysapi.qualys.eu/api/2.0/fo/knowledge_base/vuln/?action=list&details=All", [Headers=[Authorization="Basic XXXXXXXXXXXXXXXXX", #"X-Requested-With"="Detection"]])),
#"Changed Type" = Table.TransformColumnTypes(VULN,{{"QID", Int64.Type}, {"VULN_TYPE", type text}, {"SEVERITY_LEVEL", Int64.Type}, {"TITLE", type text}, {"CATEGORY", type text}, {"LAST_SERVICE_MODIFICATION_DATETIME", type datetime}, {"PUBLISHED_DATETIME", type datetime}, {"PATCHABLE", Int64.Type}, {"DIAGNOSIS", type text}, {"PCI_FLAG", Int64.Type}, {"CONSEQUENCE", type text}, {"SOLUTION", type text}})

in
#"Changed Type"

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

[BI_Analyticz]

Hi Kelly thanks for replying. Which code you are referring to?

[v-kelly-msft]

Hi  @BI_Analyticz ,

I hope you could remove below codes and test whether you still have the above issue:

Table0 = Source{0}[Table],
VULN_LIST = Table0{0}[VULN_LIST],
VULN = VULN_LIST{0}[VULN],

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

[BI_Analyticz]

Guys any helps

[M_van_Tuijl]

Hi @BI_Analyticz 

I was struggeling with the same issue and i found the solution that worked for me in this article

Solved: Power BI Desktop automatic refresh queries one-by-... - Microsoft Fabric Community

I hope it helps

Regards

Michel