Forum Discussion
jinlei19906
3 years agoFrequent Visitor
Cannot set scheduled refresh for odata with parameter in URL
Hello Power BI Community, I have built a simple power query to retrieve data from a given odata URL. It is data from SAP, shown in XML format instead of Json. Here is the query that I used. ...
- 3 years ago
Have you already read this article?
Otherwise, you can switch to Web.Contents with RelativePath/Query and create a function to handle the xml extraction.
Pat
ppm1
3 years agoSolution Sage
Have you already read this article?
Otherwise, you can switch to Web.Contents with RelativePath/Query and create a function to handle the xml extraction.
Pat
jinlei19906
3 years agoFrequent Visitor
Thank you for the advice. I tried the way in the link but I think my odata version does not support the use of parameter alias. I solved this by using the web contents instead.