Excelerator Blog - Articles on Power BI, DAX, Data Modelling & more
Directquery Connection

Data Modelling for DirectQuery

In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections.  In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery […]

Read More »

Connection Mode

Import vs DirectQuery in Power BI

Over the last few months, I have received a number of very similar questions at either one of our Live Training courses or from a student attending one of our Ask Anything Power BI Q&A sessions.  These questions all revolved around DirectQuery and were often specifically about performance issues or […]

Read More »

Paginated Reports Button

Build a Power BI Paginated Report Online

Back in April 2022, I wrote an article called Poor Man’s Paginated Reports. That article covered an easy way to create a paginated report without having to learn how to use paginated report builder. Sometime since then, Microsoft has released the ability to create a simple paginate report online inside […]

Read More »

PowerPoint Integration with Power BI Visuals

Microsoft has just announced the general availability (GA) of the integration of Power BI with PowerPoint. I have previously blogged about this feature here => Power BI Live Embedding. With the recent GA announcement comes a significant improvement over the public preview version. Power BI Single Visual Embedding in PowerPoint […]

Read More »

Excel

Major Update to Power Pivot

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via […]

Read More »

Scroll to Top