Episode

Power BI to SAP Connectivity

with Ross LoForte

SAP on Azure training videos

Learn how to connect Power BI with SAP in different scenarios including Single Sign On, ODBC connectivity, SAP HANA Connector, SAP BW Connector, SAP BW Connector Demo and many more.

Chapters

  • 00:00 - Introduction
  • 00:40 - What is Power BI?
  • 01:52 - Power BI Overview
  • 03:12 - On-premises data gateway
  • 05:39 - Single Sign-On Support when connecting to SAP from Power BI
  • 07:32 - SAP Connectivity Options in Power BI
  • 08:18 - SAP HANA Connector Overview Specialized Connector for SAP HANA
  • 09:28 - HANA Connector - Relational vs Multidimensional Direct Query Mode
  • 10:35 - SAP HANA DirectQuery Options
  • 11:53 - SAP HANA - M function
  • 16:54 - SAP BW Connector Overview
  • 18:36 - SAP BW Power Query function
  • 20:19 - SAP Business Warehouse Message Server
  • 20:36 - SAP BW Connector architecture
  • 21:47 - SAP BW Connector "2.0"
  • 23:09 - Navigating the Query Objects in SAP BW
  • 23:55 - Power BI Desktop with SAP BW Variables
  • 25:48 - What do these connectors have in common?
  • 31:28 - SAP Connectors - Performance
  • 33:29 - Report Authoring
  • 35:38 - Incremental Refresh
  • 37:37 - Query Folding
  • 40:54 - Out of Memory
  • 41:51 - Advanced Tracing Standard Trace-File - Options and Settings - Options - Diagnostics
  • 43:29 - Tip 5: Query troubleshooting
  • 44:36 - Session resources SAP HANA Connector Overview

Connect

Power BI