Category: Power BI

Super Charge Power BI: Power BI is Better When you Learn to Write DAX
Super Charge Power BI: Power BI is Better When you Learn to Write DAX
Ebooks

Data analysis expressions (DAX) is the data modelling language of Excel Power Pivot and Power BI. DAX language and DAX functions are the same in both Excel and Power BI and hence the knowledge is transferable between the two. The only difference is getting familiarised with the corresponding interfaces. This book is written to give you exactly that – hands-on practice. Inside you will find explanation of the concepts, sample… READ MORE

Data Virtualization in Microsoft Power BI – Part 2
Data Virtualization in Microsoft Power BI – Part 2
Blog Posts

In my previous post I showed how you can use Microsoft Power BI to create a Data Virtualization layer on top of multiple relational data sources querying them all at the same time through one common model. As I already mentioned in the post and what was also pointed out by Adam Saxton (b, t) in the comments… READ MORE

Data Virtualization in Microsoft Power BI
Data Virtualization in Microsoft Power BI
Blog Posts

Data Virtualization is actually a very new topic to me as I have barely seen it implemented in the real world or at any of my customers. But it becomes more and more interesting when working with big data where you cannot simply load all data into a single in-memory data model but still need… READ MORE

Tabular and Power BI - model size
Tabular and Power BI – model size
Blog Posts

Introduction Power BI users, hold on, the article will be relevant to you 🙂 Maybe 🙂 The relatively frequent question I receive at conferences and training on analytical services is: When to use Multidimensional, when to use Tabular (Power BI runs on Tabula). There’s no quick answer (and maybe a separate blog post). One of… READ MORE

Beginning Power BI - Data Munging with Power Query
Beginning Power BI – Data Munging with Power Query
Ebooks

Analyse your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualisations and share them with your colleagues. This excerpt ‘Data Munging with Power Query’ from the book Beginning Power BI by Dan Clark… READ MORE