Forum Discussion
Unable to get data from rest API error 409 conflict
Community SupportHi Anonymous ,
Try below method:
For details,check below reference :
Best Regards,
Kelly
Did I answer your question? Mark my raeply as a solution!
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"
Guys any helps
Hi Anonymous
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
- v-kelly-msft
Hi Anonymous ,
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,
KellyDid I answer your question? Mark my raeply as a solution!
Hi Kelly thanks for replying. Which code you are referring to?
- v-kelly-msft
Hi Anonymous ,
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,
KellyDid I answer your question? Mark my raeply as a solution!
