Forum Discussion
Unable to get data from rest API error 409 conflict
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
- M_van_Tuijl2 years agoNew Member
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