Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI connectivity to SOAP API WSDL(XML)

Hi All,   I have a requirement to connect SOAP API(WSDL) to Power BI. I have done a research and I understand that there is no direct connectivity yet and we can make use of the third party drivers...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Have you tried to create XML file (poste.xml) for the SOAP web service as JasonL's post in this similar thread? You can use XML.Tables() function to load data from SOAP source to Power BI Desktop. Then publish it to service.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    I have used it , but somehow I do not get the table fields when I load the query.

    This is how it looks. I expand the table, and I still do not find the columns in it.

     

    Thanks

    Poojitha