© Reza Rad 2018
Reza RadPro Power BI Architecturehttps://doi.org/10.1007/978-1-4842-4015-1_25

25. Power BI and Excel

Reza Rad1 
Meadowbank, Auckland, New Zealand

Power BI and Excel are longtime friends of each other, not only because Power BI components are coming from add-ins that were introduced in Excel, but also because of the way that these two tools interact with each other from the Power BI Service. This chapter is not about using Power Query or Power Pivot components in Excel. This chapter is about the interaction between Excel and Power BI through the service.

On one hand, Power BI and Excel integration through the service gives the user the ability to use Excel as their slicing and dicing tool while connected to a live Power BI dataset. ...

Get Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.