cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BI_Analyticz
Helper V
Helper V

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.

 

BI_Analyticz_0-1631529614132.png

 

6 REPLIES 6
v-kelly-msft
Community Support
Community Support

Hi  @BI_Analyticz ,

 

Try below method:

vkellymsft_0-1631760765153.png

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!

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"

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!

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

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!

Guys any helps

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors