Category: Tutorial

Connecting to SAP BW using Power BI Desktop

Today I connected to SAP BW using the connector available in Power BI Desktop. Following link does a good job explaining the steps: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/ Ran into a road block while installing SAP Netweaver RFC SDK library. With the help of bases team I downloaded SAP Netweaver SDK library. However there is no explanation as to where/how this

Continue reading

POWER BI TUTORIAL : Using Variables in DAX

Earlier this year, new version of DAX was released. One of the key features with this release is the support for variables. Variables makes writing DAX code easier. Variables also make code easier to read and understand. Download sample data here. Data represents sales for a particular store. Products are categorized by seasonality and color.

Continue reading

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