Connecting Power BI in Office 365 with SAP

Scheduled Data Refresh in the Cloud In this article, we will look at how Power BI workbooks in Office 365 can be automatically refreshed with data from on-premise SAP data sources. With Microsoft’s Data Management Gateway, on-premise data sources can be connected with Power BI workbooks in Office 365. You can use the Data Management Gateway to schedule automated data refreshes and provide your Power BI users with up-to-date reports and business insights in the cloud. Connecting to on-premise SAP data In previous articles on the topic of Connecting Power BI with SAP,…continue reading →

Connecting Power BI with SAP – Part II

Part II: Visualizing Customer Sales Data in Power Map Power Map is a great tool for visualizing business data on a map, using the familiar Excel application. With a few steps, the Excel user can create interactive scenes, showing multiple layers of data and dynamically changing data over time on a 3D map. Power Map works with data that has been loaded into a spreadsheet or into a Power Pivot data model. Creating a Power Map on top of your data is pretty straight forward – all you need is location data and…continue reading →

Connecting Power BI with SAP – Part I

Part I: Analyzing Employee Data in Power View Power View is a great tool for visualizing and analyzing data, using the familiar Excel application. With a few steps, the Excel user can create interactive presentations of data, for example in form of charts or maps. Power View works with data that has been loaded into a spreadsheet or into a Power Pivot data model. Creating a Power View on top of your data is relatively straight forward - with the right data in the right format. If you have worked with SAP data…continue reading →