Forum Discussion
Explore Data in Power Query coming from Succesfactors
Hello, I have an issue on how to explore the data that I am bringing from SF, I can establish the connection between Power BI and SF using the web connector. However at the moment where I want to ...
Dich123
I guess your API source is giving the result in XML format and you need to have good understnading on its structure to retrieve the required columns. Since the xml result of each API can be different, there is no other option but to expand every column required.
SAP BW can give a flat table as a result and this is the reson why you dont need to expand anything and power query will exapnd it automatically.
Hope this answers your question.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank you tharunkumarRTK for your answer, However is there any way to get the data as a flat file?