You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the ribbon of Power BI publisher for Excel In both cases,…  Read more

In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago.  Read more

Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have…  Read more

Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example, it does  Read more

Today I observed an issue on a notebook where Excel 2016 was installed and then removed, going back to Excel 2013. After this operation, workbooks having a Power Pivot data model were working correctly by navigating data in PivotTables, but any operation  Read more

I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customers  Read more

The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users: Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file Live Analysis Services Connections  Read more

Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release: Tracing (query plans and server timings) available for Power Pivot Basic implementation of Intellisense Connect to Multidimensional SSAS servers Support for multiple Power BI Desginer  Read more

If you have a PowerPivot workbook created with Excel 2010, in order to navigate and/or update the data model with Excel 2013 you need to upgrade the workbook.  Read more

An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day  Read more