en en ms fi da da da da ca da en da ms hbs_lat ms ms ms en da da ms ms da es da de ro en da da da da de da da de en it da da da es da da en da da da en da sv de da en da en en en en en da pt fr fr en de en sv da da da da sv da da en en en en es en nl en en en en en en en en en en en en en en en en en en en en en en en en de en en en sco en en en en en da da da da da en da da da da da en tr da ca en en id en en en en en en en en ms ms ms en en ml da en en nl nl da en da de de en en nl en en nl nl sv en da de de en en nl en en nl nl sv en da de de en en nl en en sv nl da en da de da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da de de en en nl en en nl nl da en da de de en en nl en en nl nl da en da de de en en nl en en nl en da ms en en en sv da fr da it de en ms ms en it da da de en en en sv da en da en da da en da da da hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko da nl nl pl pt pt ru sv th tr zh zh ar he
Connecting to SAP Business Warehouse Server using Power BI | Microsoft Power BI-blog | Microsoft Power BI
Office 365 + Power BI
Group Program Manager - Data Integration
One of te new features in te Power BI Desktop March Update is a new connector for SAP Business Warehouse Server. This connector is currently available as a Preview feature, allowing Power BI and SAP customers to evaluate its capabilities and share feedback with our team to help us improve its functionality before making it available as a mainstream, fully supported, Power BI connector.
In order to try out this connector, you will need to:
Install te Power BI Desktop March Update
Install te SAP RFC SDK (version 6.4 or greater) in your local machine (that is, te machine that is running Power BI Desktop). You can get this component from your SAP Administrator, or directly from te SAP Service Marketplace.
Enable te “SAP Business Warehouse Connector” Preview feature in Power BI Desktop. This can be done from te File menu, under “Options and Settings -> Options -> Global -> Preview Features”. Note that you will need to restart Power BI Desktop after enabling this feature.
After performing step #3, you will need to close and reopen Power BI Desktop. Once in te new Power BI Desktop instance, you will be able to find te new connector under te “Get Data” dialog, within te Database category.
After selecting this connector in te “Get Data” dialog, users will need to specify a Server, System Number and Client ID in order to establish te connection.
Note that users could also specify two additional Advanced Options: Command Timeout for connecting to te data source and a custom MDX statement to run against te specified server.
If users did not specify an MDX statement to run, they will be presented with te Navigator dialog. This dialog allows users to see te list of cubes available in te server and drill down to explore and select items from these cubes, including dimensions and measures. Please note that Hierarchies and variables/parameters are currently not supported in this Preview version, but will be supported in te future.
Users can select one or more items from te server and this will generate a preview of te output table, based on their selection.
This dialog also exposes a couple of “Display Options” that will allow users to:
Display “Only Selected Items” vs. “All Items” (default view): this option is useful for verifying te final set of items selected. An alternative way of seeing this consists on checking te Column Names in te Preview area.
“Enable Data Previews” (default behavior): Users can also control whether data previews should be displayed in this dialog or not. Disabling data previews will reduce te amount of server calls as it will no longer request data for te previews.
“Technical Names”: SAP BW supports te notion of “technical names” for objects within a cube. Technical names allow a cube owner to expose “user friendly” names for cube objects, as opposed to only exposing te “physical names” for those objects in te cube.
After selecting all necessary objects in te Navigator, users can decide what to do next, by selecting one of te following options in this dialog:
Load: This button will trigger loading te entire set of rows for te output table into te Power BI Desktop data model, bringing te users into te Report view where they can start visualizing te data or making further modifications via te Data & Relationships views.
Edit: This button will take te user into te Query Editor dialog. Te Query Editor dialog allows users to apply additional data transformations and filtering steps to their data before te entire set of rows is downloaded to te data model.
Note that, in addition to importing data from SAP BW cubes, users can also import data from a wide range of additional data sources in Power BI Desktop and combine data from multiple sources into a single report. This opens up lots of interesting scenarios for reporting and analytics on top of SAP BW data.
We hope that you give this Preview connector a try and share feedback about te experience and capabilities with us, by using te “Send a Smile/Frown” buttons in Power BI Desktop. We will take your feedback into account as we consider additional improvements to this new connector.
Learn More about Power BI connectivity options to SAP
Do you want to learn more about te SAP BW connector and other SAP connectivity options in Power BI? If so, you will want to join te upcoming “Connecting to SAP data with Power BI” webinar.
Business Analysts and Business Users who currently work with SAP HANA and SAP BW, and need to visualize their data plus share insights
April 21, 2016  10:00 AM – 11:00 AM Pacific Time. REGISTER NOW!
Follow @MSPowerBI on Twitter
Join te conversation at te Power BI Community
Tilmeld dig Power BI-nyhedsbrevet
Tilmeld dig nedenfor for at modtage de seneste nyheder fra Power BI direkte i din indbakke.
Land Afghanistan Albanien Algeriet Amerikansk Samoa Andorra Angola Anguilla Antarktis Antigua og Barbuda Argentina Armenien Aruba Aserbajdsjan Australien Bahamas Bahrain Bailiwick of Jersey Bangladesh Barbados Belgien Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnien-Hercegovina Botswana Bouvetøen Brasilien Brunei Darussalam Bulgarien Burkina Faso Burundi Cabo Verde Cambodja Cameroun Canada Caymanøerne Chile Cocosøerne (Keelingøerne) Colombia Comorerne Congo Cookøerne Costa Rica Côte d'Ivoire Curaçao Cypern Danmark De Amerikanske Jomfruøer De Amerikanske oversøiske øer De Britiske Jomfruøer De Forenede Arabiske Emirater Den Centralafrikanske Republik Den Demokratiske Republik Congo Den Dominikanske Republik Det Britiske Territorium i Det Indiske Ocean Det palæstinensiske selvstyre Djibouti Dominica Ecuador Egypten El Salvador Eritrea Estland Etiopien Falklandsøerne Fiji Filippinerne Finland Frankrig Fransk Guyana Fransk Polynesien Franske Oversøiske Områder Færøerne Gabon Gambia Georgien Ghana Gibraltar Grenada Grækenland Grønland Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard- og McDonaldøerne Honduras Indien Indonesien Iran Irland Island Isle of Man Israel Italien Jamaica Jan Mayen Japan Jordan Juleøen Kasakhstan Kenya Kina Kirgisistan Kiribati Korea Kosovo Kroatien Kuwait Laos Lesotho Letland Libanon Liberia Liechtenstein Litauen Luxembourg Madagaskar Malawi Malaysia Maldiverne Mali Malta Marokko Marshalløerne Martinique Mauretanien Mauritius Mayotte Mexico Mikronesien Moldova Monaco Mongoliet Montenegro Montserrat Mozambique Namibia Nauru Nederlandene Nepal New Zealand Nicaragua Niger Nigeria Niue Nordmakedonien Nordmarianerne Norfolk Island Norge Ny Kaledonien Oman Pakistan Palau Panama Papua Ny Guinea Paraguay Peru Pitcairn Polen Portugal Puerto Rico Qatar Reunion Rumænien Rwanda Saba Saint Barthélemy Saint Kitts og Nevis Saint Lucia Saint Martin Saint Pierre og Miquelon Saint Vincent og Grenadinerne Salomonøerne Samoa San Marino São Tomé og Príncipe SAR Hongkong SAR Macao Saudi-Arabien Schweiz Senegal Serbien Seychellerne Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakiet Slovenien Somalia South Georgia og De Sydlige Sandwichøer Spanien Sri Lanka St. Helena, Ascension, Tristan da Cunha Storbritannien Sudan Surinam Svalbard Sverige Swaziland Sydafrika Sydsudan Syrien Tadsjikistan Taiwan Tanzania Tchad Thailand Timor-Leste Tjekkiet Togo Tokelau Tonga Trinidad og Tobago Tunesien Turkmenistan Turks- og Caicosøerne Tuvalu Tyrkiet Tyskland Uganda Ukraine Ungarn Uruguay USA Usbekistan Vanuatu Vatikanstaten Venezuela Vietnam Wallis og Futunaøerne Yemen Zambia Zimbabwe Ækvatorialguinea Østrig Ålandsøerne
Jeg vil gerne modtage Power BI-nyhedsbrevet. Erklæring om beskyttelse af personlige oplysninger.
Deltagelse kræver, at dine personlige oplysninger overføres til andre lande, som Microsoft driver forretning i, herunder USA. Når du sender denne formular, accepterer du overførslen af dine data uden for Kina. Erklæring om beskyttelse af personlige oplysninger.
Hvad er Power BI?
Power BI er en pakke med virksomhedsanalyseværktøjer til dataanalyse og vidensdeling. Overvåg din virksomhed, og få hurtigt svar med omfattende dashboards, der er tilgængelige på alle enheder.
Få de seneste nyheder fra Power BI-blog
Abonner via mail Du skal angive en gyldig mailadresse Du har angivet en personlig mailadresse. Angiv din arbejds- eller skolemailadresse. Noget gik galt. Prøv igen senere.
Beskyttelse af personlige oplysninger og cookies