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
Month: August 2015
POWER BI TUTORIAL : HOW TO SURFACE EXCEL REPORTS IN POWER BI SERVICE
There are a couple of options to surface Excel Reports in Power BI Service. Download the sample file to OneDrive. The file contains a PivotTable report and a Power View report. Sign into PowerBI.com and from the left panel click on Get Data From the Get Data screen, click on Get button under Files section … Continue reading POWER BI TUTORIAL : HOW TO SURFACE EXCEL REPORTS IN POWER BI SERVICE
Power BI Tutorial: Transform data from folder data source
Data for the tutorial can be obtained by downloading CSV files from: https://www.census.gov/popest/data/intercensal/state/ST-EST00INT-02.html For the tutorial I downloaded data for Alabama, Alaska and Arizona into a folder. Open the CSV files, and notice that all of them have the same layout. In this tutorial we are going to: Read data from the folder data source … Continue reading Power BI Tutorial: Transform data from folder data source
Power BI Desktop Tutorial: Building a Star Schema from an Excel Source
An updated version of this tutorial (including a video lecture) is available here: https://businessintelligist.com/?p=2718 This tutorial shows how to create a Star Schema using Power BI Desktop. Data for the tutorial can be obtained by downloading Excel file from here Very often our analysis starts with a flat data set that contains all of the … Continue reading Power BI Desktop Tutorial: Building a Star Schema from an Excel Source
business intelligist 