BPW stands for Business Performance Warehouse, which is Kemin's data warehouse. A data warehouse consolidates and integrates data from different systems and transforms the data to ensure consistencies between disparate system information. Kemin's BPW copies and integrates data from M3, KBL. iCIMS, Nemesis, Nexa, etc. This tutorial teaches you how to connect to BPW on Power BI Desktop.

 

BPW contains multiple databases such as Nemesis, M3FDBKMN, KBL, etc. Depending on your own needs, you should connect to one of the databases available on BPW. In this tutorial, we will be connecting to the Northwind database, which is a  test database we published to the server for educational purposes. Northwind is a sample dataset developed by Microsoft that contains sales data from a fictitious company called Northwind.

 

Connecting to BPW

 

  1. On a new blank Power BI Desktop file, choose "SQL Server"

Untitled - Power 81 Desktop Home copy Paste Format painter Cjllpbærd Insert Get data Modeling View Help Enter data Transform data Refres h Search New Quick Excel workbook Power BI datasets sac erver Dataverse Recent sources Text visual box More visuals Sensitivity Pub lish

 

  1. Type bpw.kemin.com in the Server blank. Then type the name of the database you want to connect to in the Database (optional) blank.  For this tutorial, it will be Northwind. If you want to connect to the datamarts, type BPW_Datamarts in the Database blank.

  1. Choose the tables needed in your report, then select Load or Transform Data depending on your next steps. After a few moments, you should see the tables you chose in the Fields pane (f you selected load) or the Queries pane (if you selected Transform Data).

x Navigator Display Options Products Above Average Price Products by Category Quarterly Orders Sales by Category Sales Totals by Amount Summary of Sales by Quarter Summary of Sales by Year Categories CustomerCustomerDemo CustomerDemographics Customers Emplcyees EmployeeTerritones Order Details Orders Produ Cts Region Shippers Suppliers Territories Select Related Tab'es P Order Details Order' D 10248' 10248 10248 ( 10249 10249? 10250 10250 10250 ( 10251 10251 10251) 10252 102521 10252 10253 102531 10253 10254 10254 10254 10255t 10255 10255 Product' D UnitPrice Quantity 14.00 18_60 16.80 15.60 16.80 27.20 10.00 1440 : 16.00 19.20 15.20 15.20 O ; Value O' Value O, Value o i Value O: Value O: Value 0150000006t Value 0150000006 Value J Value o. 050000001 0050000001 Value O , Value 0050000001 Value 0050000001 Value O: Value O e Value o i Value O ; Value 01500000061 Value 0150000006' Value Transform Data o i Value O: Value O : Value O; Value Cancel

 

 

Troubleshooting

 

A window may pop up and ask you for which credentials to use to access the database. Choose Use my current credentials, then select Connect.

 

Windows Microsoft account SQL Server database i uskibpw2;Northwind use your Windows credentials to access this database. @ Use my current credentials O IJse alternate credentials user name Password Select which level to apply these settings to uskibpw2

 

You might be able to connect to your desired database successfully, or the following issues may occur.

 

Issue 1: Encryption Support

If a window asking you to use an unencrypted connection to connect to the data source, simply select Ok.

Encryption Support We were unable to connect to the data source using an encrypted connection. To access this data source using an unencrypted connection, click OK.

 

Issue 2: Credentials denied

If the following message appears after you click Connect, then contact IT ([email protected]) and ask them to check your credentials for the specific database you are trying to access.

 

Windows Microsoft account SQL Server database i uskibpw2;M3FDBKMN We couldn't authenticate with the credentials provided. Please try again. Use your Windows credentials to access this database. Use my current credentialS O Use alternate credentials User name Password Select which level to apply these settings to u ski bpw2