Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Extending Microsoft Business Central with Power Platform

You're reading from  Extending Microsoft Business Central with Power Platform

Product type Book
Published in Aug 2023
Publisher Packt
ISBN-13 9781803240718
Pages 458 pages
Edition 1st Edition
Languages
Concepts
Authors (2):
Kim Congleton Kim Congleton
Profile icon Kim Congleton
Shawn Sissenwein Shawn Sissenwein
Profile icon Shawn Sissenwein
View More author details
Toc

Table of Contents (19) Chapters close

Preface 1. Part 1 – Part Fundamentals
2. Chapter 1: Business Central and Power Platform – Better Together 3. Chapter 2: Getting to Know Business Central APIs 4. Chapter 3: Connecting to Business Central in the Cloud and On-Premises 5. Chapter 4: Working with Virtual Tables and Dataverse 6. Part 2 – Doing the Work of Designing, Building, and Implementing
7. Chapter 5: Best Practices for Building Power Apps for Business Central 8. Chapter 6: Building Flows for Business Central 9. Chapter 7: Delivering Solutions 10. Part 3 – Common Business Cases in Business Central for the Power Platform
11. Chapter 8: Automating Approvals and Reducing Manual Business Processes 12. Chapter 9: Connecting Power BI for Business Central Data 13. Chapter 10: Extending Functionality by Using Several Power Platform Solutions 14. Part 4 – Tips and Tricks for Common Issues
15. Chapter 11: User Adoption and Licensing Mapping Guide 16. Chapter 12: Understanding the Center of Excellence and Why It Is a Valuable Tool 17. Index 18. Other Books You May Enjoy

Connecting to data in Power BI using out-of-the-box APIs

In Power BI, you can connect to different data sources and use Power Query to create relationships and model data. So many data source options include files, databases, power platforms, Azure, and online services. There being so many options to connect data is one of the reasons Power BI is such a powerful tool. This section will focus on two options: Online Service and File. We will use Business Central to bring data into Power BI in our examples. If you need a refresher on accessing the Business Central API, refer to Chapter 2; with so much to cover in this chapter, I will get right to it. Here are the steps for connecting to data in Power BI:

  1. Open Power BI Desktop and ensure you are logged in under the user that you have access to in Business Central. Select Get data on the home page ribbon | Business Central under Online Services and select Connect. Once the navigator screen is available, you will see Business Central...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}