{"id":38565,"date":"2022-08-27T21:05:19","date_gmt":"2022-08-27T19:05:19","guid":{"rendered":"http:\/\/54.194.80.134.nip.io\/microsoft-power-bi-reporting-with-data-from-sap-bw\/"},"modified":"2022-09-27T14:59:54","modified_gmt":"2022-09-27T12:59:54","slug":"microsoft-power-bi-reporting-with-data-from-sap-bw","status":"publish","type":"post","link":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/","title":{"rendered":"Microsoft Power BI Reporting with data from SAP BW"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"38565\" class=\"elementor elementor-38565 elementor-38545\" data-elementor-settings=\"{&quot;element_pack_global_tooltip_width&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_width_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;element_pack_global_tooltip_padding&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_padding_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true},&quot;element_pack_global_tooltip_border_radius_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;top&quot;:&quot;&quot;,&quot;right&quot;:&quot;&quot;,&quot;bottom&quot;:&quot;&quot;,&quot;left&quot;:&quot;&quot;,&quot;isLinked&quot;:true}}\" 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\tAs a self-service reporting tool, Microsoft Power BI offers many useful features for the quick and easy creation of graphical analyses and dashboards.\r\n\r\nThe integration into the Office 365 Suite also provides flexible deployment options.\r\n\r\nPower BI supports a variety of different data sources. Especially for companies that have SAP BW in use, however, the connection of this is in the foreground.\r\n\r\nThis blog post deals with the various options for connecting SAP BW to Microsoft Power BI.\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 fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"211\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/blog4-300x211.png\" class=\"attachment-medium size-medium wp-image-38519\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/blog4-300x211.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/blog4-1024x721.png 1024w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/blog4-768x540.png 768w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/blog4.png 1377w\" 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\">The Power BI Architecture - Overview<\/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\tPower BI provides two different connection paths for accessing SAP BW &#8211; \/ SAP HANA &#8211; systems. In the first variant, the source data relevant for the reports is imported completely into Power BI. In the second, the source system is accessed directly; the report data is thus re-extracted at runtime.\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-b0b39a3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b0b39a3\" 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-c9391a8\" data-id=\"c9391a8\" 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-05bcb82 elementor-widget elementor-widget-image\" data-id=\"05bcb82\" 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\/elementor\/thumbs\/Blog2-qeyj5i901l9aq0g0e0e61s9cmygtmzmgmv0w5ywcze.png\" title=\"Blog2\" alt=\"Blog2\" 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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-e608b0a\" data-id=\"e608b0a\" 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-6aa1d39 elementor-widget elementor-widget-text-editor\" data-id=\"6aa1d39\" 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\tIn both cases, a so-called dataset is created during report generation and uploaded to the Power BI server.\r\n\r\nIn the case of the import solution, the underlying data is included in the dataset. In the case of direct data access, on the other hand, it only contains the metadata, such as the connection information, to establish the connection to the respective SAP BW \/ SAP HANA. The following figure shows the two types of connectivity schematically.\r\n\r\nWhile with the import variant the report requests can be served directly from the dataset, with &#8220;direct access&#8221; they are forwarded to the underlying SAP system; the report result is thus fed directly with current data.\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\tFrom an architectural perspective, data provisioning in Power BI, when using direct access (via Direct Query), is based on the following principle:\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-61da970 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"61da970\" 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-df6e350\" data-id=\"df6e350\" 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-f2b8e22 elementor-widget elementor-widget-text-editor\" data-id=\"f2b8e22\" 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<ul>\r\n \t<li>Power BI creates a query to the on-premise data source and sends it, with encrypted credentials, to the Gateway Cloud Service.<\/li>\r\n \t<li>The Gateway Cloud Service parses the query and transmits the request to Power BI&#8217;s own message management service.<\/li>\r\n \t<li>The Azure Service Bus message management service manages the request queue and ultimately passes the requests to the on-premise Data Gateway.<\/li>\r\n \t<li>The on-premise Data Gateway decrypts the credentials and uses these credentials to connect to the respective SAP data source.<\/li>\r\n \t<li>The data query is executed in the source; the results are then returned to Power BI via the on-premise Data Gateway and Azure Service Bus, where they are used to update reports.<\/li>\r\n<\/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-9d5baee\" data-id=\"9d5baee\" 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-ba0764c elementor-widget elementor-widget-image\" data-id=\"ba0764c\" 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\t<a href=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Blog1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6IjM4NTA3IiwidXJsIjoiaHR0cHM6XC9cL3d3dy5jdWJlc2Vydi5jb21cL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjJcLzA4XC9CbG9nMS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/elementor\/thumbs\/Blog1-qeyj56ywjq1zpa2y51bxmw3guu8zor55b03qa7ev6i.png\" title=\"Blog1\" alt=\"Blog1\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t<\/a>\n\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-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\tIn contrast to the Direct Query Variant, the Import option does not involve a continuous data exchange with the source system. Instead, a snapshot of the most recently uploaded data (previously uploaded to the Power BI server) is accessed in the Dashboards and reports.\r\n\r\nHowever, it is possible to automatically update the imported data by directly accessing the source system at certain time intervals. For this purpose, the dataset is linked to a local Data Gateway that contains the concrete system connection parameters.\r\n<h3>Setting up a local Data Gateway<\/h3>\r\nThe setup of an on-premise Data Gateway is always required if an automated data exchange is to take place between Power BI and an SAP source system. This applies to both the Direct-Query and the Import variant. With the latter option, it is also possible to manually upload the data to the Power BI server again. However, this method is not recommended for more complex applications (with different source data and high data update requirements).\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\">Advantages and disadvantages of the data connectivity variants<\/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\tIn the previous sections, the most important difference between the two data connectivity variants was already discussed &#8211; the storage of the data in or outside the Cloud. If the data is stored directly on the Power BI server, Power BI and the underlying VertiPaq engine can show their strengths to the full &#8211; especially in the area of performance. The navigation within the Dashboards and reports runs noticeably smoother!\r\n\r\nIn addition to performance, however, there are a number of other aspects that should be taken into consideration when comparing the two variants. For example, the import variant also has some not insignificant restrictions. The following table provides an overview of the most important aspects that should be weighed up before making a design decision. The table refers to the use of native BW objects (query, InfoCube, etc.).\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 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\" width=\"1024\" height=\"421\" src=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog3-1024x421.png\" class=\"attachment-large size-large wp-image-38525\" alt=\"\" srcset=\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog3-1024x421.png 1024w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog3-300x123.png 300w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog3-768x316.png 768w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog3-1536x632.png 1536w, https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog3.png 2001w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\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\">Conclusion<\/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\tAfter a detailed analysis of the two connectivity options, we draw the following conclusion:\r\n\r\nWhile the direct query connection has three major strengths: high data timeliness, local storage of source data, and reusability of BW authorization logics, it has a lot of restrictions in terms of report generation. A major deficit is that only one BW query can be connected per application. In addition, there are many other minor aspects, such as the fact that only texts and not key values can be displayed for characteristics. The report creation options are thus limited in a certain way with this variant. If an overall score had to be given, the features and capabilities would therefore be placed in the midfield.\r\n\r\nIn contrast, the import variant fully supports many of the features that make up Power BI (data modeling and transformation, multisourcing and fast performance). From a reporting perspective, this is clearly the better variant! However, due to the deficits in terms of data timeliness and the limited reusability of established BW logics (authorizations, time-dependent hierarchies, multilingualism), there can be no top grade here either. In the end, however, the evaluation is always very much dependent on the respective reporting requirements. A thorough analysis of the advantages and disadvantages should therefore always be the prelude to a decision on the introduction of Power BI as a reporting tool.\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-cd941f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cd941f1\" 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-baeda81\" data-id=\"baeda81\" 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-c49eeeb elementor-widget elementor-widget-text-editor\" data-id=\"c49eeeb\" 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>Outlook<\/h3>\r\nIn addition to using BW objects to provide data, it is also possible to directly use the data of the underlying HANA database. An analysis, as well as advantages and disadvantages, can be found in the <strong>next blog entry<\/strong>.\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\">Arrange now your<\/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\">We are glad to hear from you.<\/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\/2022\/08\/Robert-Schmidl-300x300.jpg\" alt=\"Picture of Robert Schmidl\" 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\">Robert Schmidl<\/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\">SAP BW Architect<\/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=\"\">\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<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\">n.n.<\/span>\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 offers a wide range of possibilities in terms of dashboards and data Transformation. But how can SAP BW data be used?<\/p>\n","protected":false},"author":105,"featured_media":38543,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[508,544,552],"tags":[519,586,587,461],"class_list":["post-38565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-analytics","category-business-analytics-plattform","category-power-bi","tag-data-warehouse","tag-microsoft-power-bi","tag-power-bi","tag-sap-bw"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v24.3) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Power BI Reporting with data from SAP BW - CubeServ<\/title>\n<meta name=\"description\" content=\"Microsoft Power BI offers a wide range of possibilities in terms of dashboards and data transformation. But how can SAP BW data be used?\" \/>\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\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Power BI Reporting with data from SAP BW\" \/>\n<meta property=\"og:description\" content=\"Microsoft Power BI offers a wide range of possibilities in terms of dashboards and data transformation. But how can SAP BW data be used?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\" \/>\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-08-27T19:05:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-27T12:59:54+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=\"Robert Schmidl\" \/>\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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Robert Schmidl\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\"},\"author\":{\"name\":\"Robert Schmidl\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/#\/schema\/person\/c8bb675f09215865e0ea2307fda8c06f\"},\"headline\":\"Microsoft Power BI Reporting with data from SAP BW\",\"datePublished\":\"2022-08-27T19:05:19+00:00\",\"dateModified\":\"2022-09-27T12:59:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\"},\"wordCount\":976,\"publisher\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\",\"keywords\":[\"Data Warehouse\",\"Microsoft Power BI\",\"Power BI\",\"SAP BW\"],\"articleSection\":[\"Business Analytics\",\"Business Analytics Plattform\",\"Power BI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\",\"url\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\",\"name\":\"Microsoft Power BI Reporting with data from SAP BW - CubeServ\",\"isPartOf\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png\",\"datePublished\":\"2022-08-27T19:05:19+00:00\",\"dateModified\":\"2022-09-27T12:59:54+00:00\",\"description\":\"Microsoft Power BI offers a wide range of possibilities in terms of dashboards and data transformation. But how can SAP BW data be used?\",\"breadcrumb\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#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\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/www.cubeserv.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Power BI Reporting with data from SAP BW\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/#website\",\"url\":\"https:\/\/www.cubeserv.com\/en\/\",\"name\":\"CubeServ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cubeserv.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cubeserv.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/#organization\",\"name\":\"CubeServ Group\",\"url\":\"https:\/\/www.cubeserv.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/#\/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\/en\/#\/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\/en\/#\/schema\/person\/c8bb675f09215865e0ea2307fda8c06f\",\"name\":\"Robert Schmidl\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.cubeserv.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Robert-Schmidl-150x150.jpg\",\"contentUrl\":\"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Robert-Schmidl-150x150.jpg\",\"caption\":\"Robert Schmidl\"},\"description\":\"SAP BW Architect\",\"url\":\"https:\/\/www.cubeserv.com\/en\/author\/schmidlr\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft Power BI Reporting with data from SAP BW - CubeServ","description":"Microsoft Power BI offers a wide range of possibilities in terms of dashboards and data transformation. But how can SAP BW data be used?","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\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Power BI Reporting with data from SAP BW","og_description":"Microsoft Power BI offers a wide range of possibilities in terms of dashboards and data transformation. But how can SAP BW data be used?","og_url":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/","og_site_name":"CubeServ","article_publisher":"https:\/\/www.facebook.com\/CubeServ","article_published_time":"2022-08-27T19:05:19+00:00","article_modified_time":"2022-09-27T12:59:54+00:00","og_image":[{"width":915,"height":523,"url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","type":"image\/png"}],"author":"Robert Schmidl","twitter_card":"summary_large_image","twitter_creator":"@CubeServ","twitter_site":"@CubeServ","twitter_misc":{"Written by":"Robert Schmidl","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#article","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/"},"author":{"name":"Robert Schmidl","@id":"https:\/\/www.cubeserv.com\/en\/#\/schema\/person\/c8bb675f09215865e0ea2307fda8c06f"},"headline":"Microsoft Power BI Reporting with data from SAP BW","datePublished":"2022-08-27T19:05:19+00:00","dateModified":"2022-09-27T12:59:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/"},"wordCount":976,"publisher":{"@id":"https:\/\/www.cubeserv.com\/en\/#organization"},"image":{"@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","keywords":["Data Warehouse","Microsoft Power BI","Power BI","SAP BW"],"articleSection":["Business Analytics","Business Analytics Plattform","Power BI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/","url":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/","name":"Microsoft Power BI Reporting with data from SAP BW - CubeServ","isPartOf":{"@id":"https:\/\/www.cubeserv.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#primaryimage"},"image":{"@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Blog5.png","datePublished":"2022-08-27T19:05:19+00:00","dateModified":"2022-09-27T12:59:54+00:00","description":"Microsoft Power BI offers a wide range of possibilities in terms of dashboards and data transformation. But how can SAP BW data be used?","breadcrumb":{"@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cubeserv.com\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#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\/en\/microsoft-power-bi-reporting-with-data-from-sap-bw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.cubeserv.com\/en\/"},{"@type":"ListItem","position":2,"name":"Microsoft Power BI Reporting with data from SAP BW"}]},{"@type":"WebSite","@id":"https:\/\/www.cubeserv.com\/en\/#website","url":"https:\/\/www.cubeserv.com\/en\/","name":"CubeServ","description":"","publisher":{"@id":"https:\/\/www.cubeserv.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cubeserv.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.cubeserv.com\/en\/#organization","name":"CubeServ Group","url":"https:\/\/www.cubeserv.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cubeserv.com\/en\/#\/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\/en\/#\/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\/en\/#\/schema\/person\/c8bb675f09215865e0ea2307fda8c06f","name":"Robert Schmidl","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.cubeserv.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Robert-Schmidl-150x150.jpg","contentUrl":"https:\/\/www.cubeserv.com\/wp-content\/uploads\/2022\/08\/Robert-Schmidl-150x150.jpg","caption":"Robert Schmidl"},"description":"SAP BW Architect","url":"https:\/\/www.cubeserv.com\/en\/author\/schmidlr\/"}]}},"_links":{"self":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/posts\/38565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/users\/105"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/comments?post=38565"}],"version-history":[{"count":0,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/posts\/38565\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/media\/38543"}],"wp:attachment":[{"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/media?parent=38565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/categories?post=38565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cubeserv.com\/en\/wp-json\/wp\/v2\/tags?post=38565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}