Book Image

Microsoft Power BI Cookbook

By : Author Test, Brett Powell
Book Image

Microsoft Power BI Cookbook

By: Author Test, Brett Powell

Overview of this book

Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI’s functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.
Table of Contents (14 chapters)

Migrating a Power BI Data Model to SSAS Tabular

Despite the efficient design of a Power BI dataset as well as new and future features of Power BI Premium that support larger datasets and greater performance, many organizations may choose SSAS for its rich and mature corporate BI features, such as source control integration, programmability, and partitions. With the Azure Analysis Services Web Designer, a Power BI dataset (PBIX file) can be migrated to a new SSAS Tabular project and deployed to either an on-premises SSAS server or to an Azure Analysis Services server. Additionally, via tools such as the BISM Normalizer, specific components of a Power BI Desktop model can be added to an existing SSAS Tabular project to promote reusability and consistency.

"I think it's fair to say that we're the only vendor that can claim a strong presence in self-service business...