You’re offline. This is a read only version of the page.
95
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.
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.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (