Forum Discussion
Unable to get data from rest API error 409 conflict
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.
7 Replies
v-kelly-msftCommunity Support
Hi Anonymous ,
Try below method:
For details,check below reference :
Best Regards,
KellyDid 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"