Hi All,
I have for a number of years successfully used web services to publish a page and connect to the data in excel using power query.
With Power BI now using v2.0 API's there are a number of tables already published through what is intended to be a more robust medium.
Does anybody know best practice for connecting to these API's using power query in excel rather than Power Bi?
I can connect to a header table e.g. Sales order header or a single line record e.g. item but cannot extract a lines table.
Unlike in Power Bi, Excel query does not bring in the related child table as an expandable column.
I've searched quite a lot online and have only found my own query on the same topic from last year.
Thanks in advance.