In Excel 2016, click on File -> Options -> Add-Ins From the drop down select COM Add-ins and select Go… In COM Add-Ins dialogue, if Power View for Excel is not selected, select the check box and click OK Notice that enabling the Add-In does not provide the ability to create a Power View report … Continue reading Enabling Power View in Excel 2016
Category: Excel and Excel Services
Microsoft Announces IT Pro and Developer Preview for Office 2016
New BI features include the following: Power Query is integrated into the Ribbon Three new Excel functions have been added to support forecasting Support for Slicer multi select using touch Time grouping for model based pivot tables Power View against multidimensional cubes Improved automatic relationship detection Ability to rename Power pivot measures and columns in … Continue reading Microsoft Announces IT Pro and Developer Preview for Office 2016
Microsoft Updates MDS Plug-in for Excel
New updates are focused on performance. You can download the latest version here. Although the title states it's for SQL Server 2014, the plug-in also works with SQL Server 2012.
How to Move Power View Sheets inside Excel
If you have used Power View inside Excel, you probably have noticed that Power View reports are housed inside a special type of a worksheet that does not contain traditional cells but rather looks like a canvas. The other difference is that once you have inserted a Power View worksheet in you Excel document, you … Continue reading How to Move Power View Sheets inside Excel
Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
Click here to download the data file for this tutorial. We are not always lucky to have our data neatly laid out in rows and columns. Sometimes, our data come in as a formatted report and we need to find a way to massage the data before it can be loaded into a data model. … Continue reading Power BI Tutorial: How to Use Power Query to Load Data from a Formatted Report
Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
Let's take a look at an unfortunately very familiar to most of us business scenario. A patient gets admitted to a hospital, spends several days there and then gets discharged (hopefully feeling much better 🙂 ). In this situation, we have two dates that describe this event, the date of being admitted and the date … Continue reading Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
Click Here to download this Tutorial file Very often our analysis starts with a flat data set that contains all of the pertinent columns in a single table that looks like the one above. As we can see, we can analyze this data using three different lenses or dimensions: Product Geography Date Unfortunately, if we … Continue reading Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
What is Power BI?
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?
Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function
This post will be a little bit atypical compared to what I normally write about. I usually don't focus on topics like the one described below because there are plenty of other blogs that cover developer specific issues related to using DAX. However, I ran into an issue few days ago, could not find a … Continue reading Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function
How to Use Pictures in Your Power BI Power View Dashboards
If you used pictures in your Power View dashboards and tried to deploy these dashboards in your Power BI tenant you are likely to have seen the following warning message: "UNSUPPORTED FEATURES External pictures can't be displayed in Power View Sheets in Office 365". My guess it's only a matter of time when external pictures … Continue reading How to Use Pictures in Your Power BI Power View Dashboards