Questions, Queries, and Answers with Power Query and BC Web Services
During this presentation, Connor McNamara talks about reporting options for Business Central and discusses how Power Query can be used with Excel or Power BI to build reports for Business Central and other systems.
Key Takeaways:
- How to set up Web Services in Business Central
- Authentication options for connecting to Web Services
- Using Power Query to pull Business Central data into Excel
- Merging and manipulating data in Power Query to create reports with answers
