{"id":40082,"date":"2022-10-26T14:42:19","date_gmt":"2022-10-26T12:42:19","guid":{"rendered":"http:\/\/54.194.80.134.nip.io\/?p=40082"},"modified":"2022-10-27T08:57:55","modified_gmt":"2022-10-27T06:57:55","slug":"direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/","title":{"rendered":"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"40082\" class=\"elementor elementor-40082\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8b70e5b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b70e5b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-9f1b983\" data-id=\"9f1b983\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b89297f elementor-widget elementor-widget-text-editor\" data-id=\"b89297f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Im vergangenen Blogeintrag zum Thema Reporting mit Daten aus SAP BW wurde beschrieben, wie ein SAP Business Warehouse direkt angebunden werden kann.\u00a0<\/p><p>Neben der nativen Anbindung besteht auch die M\u00f6glichkeit direkt auf die darunterliegende Datenbank zuzugreifen. Im konkreten Fall eine HANA-Datenbank, welche beispielsweise zu einem SAP BW oder S\/4HANA geh\u00f6rt.\u00a0<\/p><p>Dieser Blogeintrag befasst sich daher mit der Anbindung einer HANA-Datenbank an Microsoft Power BI und damit einhergehenden Beschr\u00e4nkungen, sowie Vor- und Nachteilen.<\/p><div>\u00a0<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-4451d28\" data-id=\"4451d28\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-896dba1 elementor-widget elementor-widget-image\" data-id=\"896dba1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"114\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/10\/SAP-HANA-300x114.png\" class=\"attachment-medium size-medium wp-image-2264\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/10\/SAP-HANA-300x114.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/10\/SAP-HANA-1024x388.png 1024w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/10\/SAP-HANA-768x291.png 768w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2019\/10\/SAP-HANA.png 1200w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dcd95dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dcd95dd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8bde1c9\" data-id=\"8bde1c9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4016fd4 elementor-widget elementor-widget-heading\" data-id=\"4016fd4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-small\">Die Power BI Architektur - \u00dcbersicht<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bccbcdf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bccbcdf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5606f5b\" data-id=\"5606f5b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9a8bf22 elementor-widget elementor-widget-text-editor\" data-id=\"9a8bf22\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>F\u00fcr die Verbindung zu einer HANA-Datenbank ist der \u201eHDB_ODBC\u201c Treiber erforderlich. Dieser muss auf dem Client bzw. dem Data Gateway installiert werden. Eine detaillierte Anleitung dazu wird hier bereitgestellt:\u00a0<\/p><p><a href=\"https:\/\/blogs.sap.com\/2021\/03\/19\/connect-to-sap-hana-database-from-microsoft-power-bibusiness-intelligence\/\">Connect to sap HANA Database from Microsoft power BI<\/a><\/p><p class=\"MsoNormal\">Im Anschluss kann eine Verbindung zu einer HANA-Datenbank aus Microsoft Power BI hergestellt werden. Dazu werden die Adresse und der Port des Servers ben\u00f6tigt sowie ein entsprechender User.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3402e89 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3402e89\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-e3e14e5\" data-id=\"e3e14e5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6959a2a elementor-widget elementor-widget-image\" data-id=\"6959a2a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"715\" height=\"425\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild1.png\" class=\"attachment-large size-large wp-image-40088\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild1.png 715w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild1-300x178.png 300w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5499baa\" data-id=\"5499baa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3fc1711 elementor-widget elementor-widget-image\" data-id=\"3fc1711\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"595\" height=\"426\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild2.png\" class=\"attachment-large size-large wp-image-40091\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild2.png 595w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild2-300x215.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-75fd909 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"75fd909\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-51f488b\" data-id=\"51f488b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7979000 elementor-widget elementor-widget-text-editor\" data-id=\"7979000\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Wenn ein Data Gateway genutzt wird, kann auch SSO zum Einsatz kommen f\u00fcr den Produktivbetrieb. Dadurch wird bei Liveverbindungen der jeweilige SAP-User des Anwenders genutzt und entsprechende Berechtigungen auf der HANA-Datenbank k\u00f6nnen weiterverwendet werden.<br \/>Eine detaillierte Beschreibung liefert diese Infoseite:\u00a0<\/p><p><a href=\"https:\/\/learn.microsoft.com\/de-at\/power-bi\/connect-data\/service-gateway-sso-kerberos#complete-data-source-specific-configuration-steps\">Konfigurieren des Kerberos-basierten einmaligen Anmeldens (Single Sign-On, SSO) im Power BI-Dienst bei lokalen Datenquellen<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cbd7f63 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbd7f63\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b9f8542\" data-id=\"b9f8542\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d85c43d elementor-widget elementor-widget-heading\" data-id=\"d85c43d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><h1>Datenkonnektierungsvarianten<\/h1><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0cd852c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0cd852c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cadce0e\" data-id=\"cadce0e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6c0e51e elementor-widget elementor-widget-text-editor\" data-id=\"6c0e51e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\">Wie \u00fcblich bietet Microsoft Power BI zwei verschiedene M\u00f6glichkeiten Daten zu konsumieren. Zum einen die Importvariante, welche die Daten in die Cloud repliziert und im Anschluss das volle Funktionsspektrum von Microsoft Power BI zur Verf\u00fcgung stellt.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6498ceb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6498ceb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-273f7c5\" data-id=\"273f7c5\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76715c4 elementor-absolute elementor-widget elementor-widget-image\" data-id=\"76715c4\" data-element_type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;absolute&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"886\" height=\"576\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild8-1.png\" class=\"attachment-large size-large wp-image-40121\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild8-1.png 886w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild8-1-300x195.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild8-1-768x499.png 768w\" sizes=\"(max-width: 886px) 100vw, 886px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-d9e89be\" data-id=\"d9e89be\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7b48723 elementor-widget elementor-widget-text-editor\" data-id=\"7b48723\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Konkret l\u00e4uft der Prozess wie folgt ab:<\/p><ol><li>Die Daten werden regelm\u00e4\u00dfig vom User oder dem Data Gateway in die Cloud repliziert.<\/li><li>Anwender bzw. Dashboard f\u00fchren bei Nutzung eine Abfrage an das Dataset aus.<\/li><li>Das Dataset liefert die gew\u00fcnschten Daten an den Anwender bzw. das Dashboard.<\/li><\/ol><p>Die zweite M\u00f6glichkeit, Daten zu konsumieren, ist die Direct-Query. Hier findet eine Live-Datenabfrage beim Aufrufen bzw. Ausf\u00fchren der Berichte\u00a0<span>statt<\/span><span style=\"font-size: 1rem\">.<\/span><\/p><p>Der Prozess l\u00e4sst sich wie folgt beschreiben:<\/p><ol><li>Anwender bzw. Dashboard f\u00fchren bei Nutzung eine Abfrage an das Dataset aus.<\/li><li>Das Dataset f\u00fchrt eine Abfrage an die HANA-Datenbank aus.<\/li><li>Die HANA-Datenbank liefert die angefragten Daten an das Dataset<\/li><li>Das Dataset liefert die gew\u00fcnschten Daten an den Anwender bzw. das Dashboard.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8ac79a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ac79a3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-38d691c\" data-id=\"38d691c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f1b7f28 elementor-widget elementor-widget-text-editor\" data-id=\"f1b7f28\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 style=\"line-height: normal;background-image: initial;background-position: initial;background-size: initial;background-attachment: initial\">Die zwei verschiedenen Arten der Direct-Query<\/h3><p>Standardm\u00e4\u00dfig werden SAP HANA Datenquellen in Microsoft Power BI als multidimensionale Quellen behandelt. Ihr Verhalten \u00e4hnelt dann z.B. dem einer SAP BW Verbindung. Bei der Verbindung sind alle Kennzahlen, Hierarchien und Attribute verf\u00fcgbar. Aggregationen finden zudem direkt auf der HANA-Datenbank statt. Die Verbindungsart bringt jedoch auch Nachteile mit sich. Darunter:<\/p><ul><li>Keine berechneten Spalten<\/li><li>Keine Beziehungen zwischen Datenquellen &#8211;&gt; Nur eine Datenquelle pro Bericht<\/li><li>L\u00f6schen von Feldern bzw. Spalten nicht m\u00f6glich<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cbce64a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbce64a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-b2f9a08\" data-id=\"b2f9a08\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d1e5fe elementor-widget elementor-widget-text-editor\" data-id=\"4d1e5fe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Zus\u00e4tzlich erlaubt Microsoft Power BI die HANA-Datenbank als relationale Datenquelle zu behandeln. Diese Einstellungen kann in den Optionen von MS Power BI direkt angew\u00e4hlt werden.<\/p><p>Die Abfragen finden dann im Rahmen von SQL statt. Die Vorteile dieser Verbindungsart sind die erh\u00f6hte Flexibilit\u00e4t. Diese umfasst das Anlegen berechneter Spalten, das Definieren von Beziehungen, wodurch mehrere Datenquellen in einem Bericht genutzt werden oder auch die M\u00f6glichkeit, nur bestimmte Felder in der Abfrage zu definieren. Die Verbindungsart bringt jedoch auch Nachteile mit sich. Darunter:<\/p><ul><li><span style=\"text-indent: -24px\">Keine Parent-Child Hierarchien<\/span><\/li><li><span style=\"text-indent: -24px\">Keine Attribut Views<\/span><\/li><li><span style=\"text-indent: -24px\">Kein nachtr\u00e4gliches \u00c4ndern von Variablen m\u00f6glich<\/span><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-19e290b\" data-id=\"19e290b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4c1e035 elementor-absolute elementor-widget elementor-widget-image\" data-id=\"4c1e035\" data-element_type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;absolute&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"208\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild4.png\" class=\"attachment-large size-large wp-image-40097\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild4.png 576w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild4-300x108.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-112dd2c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"112dd2c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ee13eec\" data-id=\"ee13eec\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a76852e elementor-widget elementor-widget-heading\" data-id=\"a76852e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Vor- und Nachteile der Datenkonnektierungsvarianten<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d3c510 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d3c510\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-394edaa\" data-id=\"394edaa\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6df6757 elementor-widget elementor-widget-text-editor\" data-id=\"6df6757\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\">Die vorgestellten Varianten der Datenkonnektierung haben\njeweils Vor- und Nachteile. Klar ist, dass die beste Performance bei vollst\u00e4ndigem\nFunktionsumfang nur bei Import-Verbindungen m\u00f6glich ist, da nur dann die Power\nBI eigene Engine zum Einsatz kommt.<\/p><p>\n\n<\/p><p class=\"MsoNormal\">Die nachfolgende Tabelle stellt die zwei bzw. drei Arten\nnochmal gegen\u00fcber und vergleicht wichtige Aspekte<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5c4cdfd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5c4cdfd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-494861e\" data-id=\"494861e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2923b2e elementor-widget__width-inherit elementor-widget elementor-widget-image\" data-id=\"2923b2e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/10\/Bild6.png\" title=\"Bild6\" alt=\"Bild6\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c29e5f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c29e5f4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2146923\" data-id=\"2146923\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3afebd4 elementor-widget elementor-widget-heading\" data-id=\"3afebd4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fazit<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-761e609 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"761e609\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f87bea8\" data-id=\"f87bea8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e066f30 elementor-widget elementor-widget-text-editor\" data-id=\"e066f30\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"MsoNormal\">Die Anbindung von HANA-Datenbanken bietet die M\u00f6glichkeit, Daten verschiedenster SAP-Anwendungen bereitzustellen. Neben nativen HANA-Views k\u00f6nnen beispielsweise auch HANA-Views aus vielen SAP BW-Objekten erzeugt werden, welche dann die Berechtigungen der BW-Objekte erben.<\/p><p>\u00a0<\/p><p class=\"MsoNormal\">Neben der bekannten Importvariante bietet der Modus f\u00fcr relationale Datenbanken die M\u00f6glichkeit, umfangreiche Dashboards auf Basis verschiedener SAP HANA Quellen in Microsoft Power BI zu erstellen, ohne die Daten in die Cloud replizieren zu m\u00fcssen. Auf diese Weise bleiben auch Berechtigungen der HANA-Datenbank erhalten. Die M\u00f6glichkeit, Beziehungen zu definieren, hilft zus\u00e4tzlich gemeinsame Diagramme und Tabellen innerhalb der Berichte zu kreieren.\u00a0<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-08917f6 elementor-section-height-min-height elementor-section-content-top elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"08917f6\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-edafc9b\" data-id=\"edafc9b\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-84c03ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"84c03ac\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-71f82e3\" data-id=\"71f82e3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-c922207 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c922207\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-9311f45\" data-id=\"9311f45\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b100c4e elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"b100c4e\" data-element_type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;underline&quot;,&quot;highlighted_text&quot;:&quot;Expert Call.&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t\t<span class=\"elementor-headline-plain-text elementor-headline-text-wrapper\">Vereinbaren Sie jetzt Ihren<\/span>\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">Expert Call.<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"elementor-headline-plain-text elementor-headline-text-wrapper\">Wir freuen uns \u00fcber Ihre Nachricht.<\/span>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-ef6b7ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ef6b7ad\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-97bc999\" data-id=\"97bc999\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-824c0bf elementor-author-box--image-valign-middle elementor-author-box--avatar-yes elementor-author-box--link-no elementor-widget elementor-widget-author-box\" data-id=\"824c0bf\" data-element_type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<div  class=\"elementor-author-box__avatar\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2023\/10\/Jan-Frederick-Sabjetzki.png\" alt=\"Picture of Jan Frederick Sabjetzki\" loading=\"lazy\">\n\t\t\t\t<\/div>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-11fb2a0\" data-id=\"11fb2a0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-59d0a39 elementor-widget elementor-widget-spacer\" data-id=\"59d0a39\" data-element_type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1a2e73 elementor-widget elementor-widget-heading\" data-id=\"d1a2e73\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Jan Frederick Sabjetzki<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7582b7f elementor-widget elementor-widget-heading\" data-id=\"7582b7f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Consultant for Business Analytics and Reporting<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-f58f98a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f58f98a\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-4d00e99\" data-id=\"4d00e99\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6a6f77a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6a6f77a\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"tel:+41552243000\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-phone-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M497.39 361.8l-112-48a24 24 0 0 0-28 6.9l-49.6 60.6A370.66 370.66 0 0 1 130.6 204.11l60.6-49.6a23.94 23.94 0 0 0 6.9-28l-48-112A24.16 24.16 0 0 0 122.6.61l-104 24A24 24 0 0 0 0 48c0 256.5 207.9 464 464 464a24 24 0 0 0 23.4-18.6l24-104a24.29 24.29 0 0 0-14.01-27.6z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">+41 55 224 30 00<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"mailto:j.sabjetzki@cubeserv.com\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-far-envelope\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M464 64H48C21.49 64 0 85.49 0 112v288c0 26.51 21.49 48 48 48h416c26.51 0 48-21.49 48-48V112c0-26.51-21.49-48-48-48zm0 48v40.805c-22.422 18.259-58.168 46.651-134.587 106.49-16.841 13.247-50.201 45.072-73.413 44.701-23.208.375-56.579-31.459-73.413-44.701C106.18 199.465 70.425 171.067 48 152.805V112h416zM48 400V214.398c22.914 18.251 55.409 43.862 104.938 82.646 21.857 17.205 60.134 55.186 103.062 54.955 42.717.231 80.509-37.199 103.053-54.947 49.528-38.783 82.032-64.401 104.947-82.653V400H48z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-dc34dbf\" data-id=\"dc34dbf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cbd0b2f elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"cbd0b2f\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/jan-frederick-sabjetzki-086701176\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4 416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1 243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">jan-frederick-Sabjetzki<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?<\/p>\n","protected":false},"author":104,"featured_media":38541,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[508,544,552],"tags":[586,587,407],"class_list":["post-40082","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-analytics","category-business-analytics-plattform","category-power-bi","tag-microsoft-power-bi","tag-power-bi","tag-sap-hana"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v23.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI - CubeServ<\/title>\n<meta name=\"description\" content=\"Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI\" \/>\n<meta property=\"og:description\" content=\"Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"CubeServ\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CubeServ\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-26T12:42:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-27T06:57:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"915\" \/>\n\t<meta property=\"og:image:height\" content=\"523\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jan Frederick Sabjetzki\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@CubeServ\" \/>\n<meta name=\"twitter:site\" content=\"@CubeServ\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jan Frederick Sabjetzki\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\"},\"author\":{\"name\":\"Jan Frederick Sabjetzki\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/ab682960b6aeea47500e2c09d1035d22\"},\"headline\":\"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI\",\"datePublished\":\"2022-10-26T12:42:19+00:00\",\"dateModified\":\"2022-10-27T06:57:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\"},\"wordCount\":728,\"publisher\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\",\"keywords\":[\"Microsoft Power BI\",\"Power BI\",\"SAP HANA\"],\"articleSection\":[\"Business Analytics\",\"Business Analytics Plattform\",\"Power BI\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\",\"url\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\",\"name\":\"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI - CubeServ\",\"isPartOf\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\",\"datePublished\":\"2022-10-26T12:42:19+00:00\",\"dateModified\":\"2022-10-27T06:57:55+00:00\",\"description\":\"Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?\",\"breadcrumb\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage\",\"url\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\",\"contentUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\",\"width\":915,\"height\":523},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/www.cubeserv.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/#website\",\"url\":\"https:\/\/www.cubeserv.com\/de\/\",\"name\":\"CubeServ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cubeserv.com\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/#organization\",\"name\":\"CubeServ Group\",\"url\":\"https:\/\/www.cubeserv.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png\",\"contentUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png\",\"width\":768,\"height\":372,\"caption\":\"CubeServ Group\"},\"image\":{\"@id\":\"https:\/\/www.cubeserv.com\/de\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/CubeServ\",\"https:\/\/x.com\/CubeServ\",\"https:\/\/www.instagram.com\/cubeservgroup\/\",\"https:\/\/www.linkedin.com\/company\/112961\/\",\"https:\/\/www.youtube.com\/user\/CubeServGroup\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/ab682960b6aeea47500e2c09d1035d22\",\"name\":\"Jan Frederick Sabjetzki\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2023\/10\/elementor\/thumbs\/Jan-Frederick-Sabjetzki-qex8tyoh4szq850r0n2b8aqx69q8at300wen4n9nq4.png\",\"contentUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2023\/10\/elementor\/thumbs\/Jan-Frederick-Sabjetzki-qex8tyoh4szq850r0n2b8aqx69q8at300wen4n9nq4.png\",\"caption\":\"Jan Frederick Sabjetzki\"},\"description\":\"Consultant for Business Analytics and Reporting\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jan-frederick-sabjetzki-086701176\"],\"url\":\"https:\/\/www.cubeserv.com\/de\/author\/sabjetzkijf\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI - CubeServ","description":"Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/","og_locale":"de_DE","og_type":"article","og_title":"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI","og_description":"Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?","og_url":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/","og_site_name":"CubeServ","article_publisher":"https:\/\/www.facebook.com\/CubeServ","article_published_time":"2022-10-26T12:42:19+00:00","article_modified_time":"2022-10-27T06:57:55+00:00","og_image":[{"width":915,"height":523,"url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","type":"image\/png"}],"author":"Jan Frederick Sabjetzki","twitter_card":"summary_large_image","twitter_creator":"@CubeServ","twitter_site":"@CubeServ","twitter_misc":{"Verfasst von":"Jan Frederick Sabjetzki","Gesch\u00e4tzte Lesezeit":"5 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#article","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/"},"author":{"name":"Jan Frederick Sabjetzki","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/ab682960b6aeea47500e2c09d1035d22"},"headline":"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI","datePublished":"2022-10-26T12:42:19+00:00","dateModified":"2022-10-27T06:57:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/"},"wordCount":728,"publisher":{"@id":"https:\/\/www.cubeserv.com\/de\/#organization"},"image":{"@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","keywords":["Microsoft Power BI","Power BI","SAP HANA"],"articleSection":["Business Analytics","Business Analytics Plattform","Power BI"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/","url":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/","name":"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI - CubeServ","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","datePublished":"2022-10-26T12:42:19+00:00","dateModified":"2022-10-27T06:57:55+00:00","description":"Microsoft Power BI bietet vielf\u00e4ltige M\u00f6glichkeiten in Bezug auf Dashboards und Datentransformation. Doch wie lassen sich SAP HANA Daten nutzen?","breadcrumb":{"@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#primaryimage","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","width":915,"height":523},{"@type":"BreadcrumbList","@id":"https:\/\/www.cubeserv.com\/de\/direktzugriff-auf-hana-datenbanken-aus-microsoft-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.cubeserv.com\/de\/"},{"@type":"ListItem","position":2,"name":"Direktzugriff auf HANA-Datenbanken aus Microsoft Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.cubeserv.com\/de\/#website","url":"https:\/\/www.cubeserv.com\/de\/","name":"CubeServ","description":"","publisher":{"@id":"https:\/\/www.cubeserv.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cubeserv.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.cubeserv.com\/de\/#organization","name":"CubeServ Group","url":"https:\/\/www.cubeserv.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2020\/07\/CubeServ_Web_Logo-768x372-1.png","width":768,"height":372,"caption":"CubeServ Group"},"image":{"@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/CubeServ","https:\/\/x.com\/CubeServ","https:\/\/www.instagram.com\/cubeservgroup\/","https:\/\/www.linkedin.com\/company\/112961\/","https:\/\/www.youtube.com\/user\/CubeServGroup"]},{"@type":"Person","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/ab682960b6aeea47500e2c09d1035d22","name":"Jan Frederick Sabjetzki","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.cubeserv.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2023\/10\/elementor\/thumbs\/Jan-Frederick-Sabjetzki-qex8tyoh4szq850r0n2b8aqx69q8at300wen4n9nq4.png","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2023\/10\/elementor\/thumbs\/Jan-Frederick-Sabjetzki-qex8tyoh4szq850r0n2b8aqx69q8at300wen4n9nq4.png","caption":"Jan Frederick Sabjetzki"},"description":"Consultant for Business Analytics and Reporting","sameAs":["https:\/\/www.linkedin.com\/in\/jan-frederick-sabjetzki-086701176"],"url":"https:\/\/www.cubeserv.com\/de\/author\/sabjetzkijf\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/posts\/40082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/users\/104"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/comments?post=40082"}],"version-history":[{"count":0,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/posts\/40082\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/media\/38541"}],"wp:attachment":[{"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/media?parent=40082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/categories?post=40082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cubeserv.com\/de\/wp-json\/wp\/v2\/tags?post=40082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}