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.
Thanks Steven, I have only just got around to testing this and can confirm it does work.
I would suggest to use Power BI Dataflows:
Power BI Dataflows now support Business Central! – think about IT
How Do I: Extract data from Business Central? – think about IT
The dataflows you can then access in Excel, Power BI Desktop,...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156