Power BI y Oracle – How to make the connection
Power BI offers multiple connection services to diverse data sources. In this article we will focus on the connection to databases On Premises of SQL Server and Oracle . As is public knowledge we have two development platforms for BI Power ( Power BI Desktop and Power BI Web ) plus component refresh information (Gateway).
Power BI Web
The Power BI Web component, as its name says, is a component accessible from any browser . This component is oriented to the generation of Dashboards and reports through the use of Services pre-established to different data sources.
Within these origins we highlight services for GitHub, Google Analytics, Azure, etc.
Being service-oriented, this component does not support connection to On Premises sources, although it allows (once created the reports in Power BI Desktop) to make modifications on the reports and structures derived from these sources.
Power BI Desktop
On the other hand, Power BI Desktop, Power BI desktop application, allows connection to sources On Premises, in which SQL Server and Oracle stand out (there are a variety of sources to which data connection can be generated).
Due to these characteristics, the interconnection of data through Power BI Desktop will be detailed below.
Connection to SQL
The connection to a SQL Server On Premises database  consists of three simple steps. The first is to choose the data source, which we can set via the Get Data-> SQL Server Database option.
In the second step we must specify the IP or HostName of the database server and the name of the same. You must also specify whether to import data directly (DirectQuery), that is, live streaming data or create an import of the data (Import) at the time of creation and each time the report is refreshed.
Optionally, we can make a query to the base so as to bring the necessary information in an orderly and already processed way. This we can make using the option Advanced options and specifying the query in the text box.
Once the connection data is completed we must specify the login credentials to the base. For this we have two options, through the use of Windows Authentication …
… or through direct authentication on the database.
When completing the data of entry, if they are correct, we will have a pre-visualization of the data of the base and its structures.
Connecting to Oracle
In order to connect to an Oracle database, it is necessary to perform certain previous steps, because specific configurations are required in order to establish the connection.
As a first step we must download and install the Java Client , for this we must determine which version of Power BI we have installed, whether 64 or 32 bits. This can be obtained by entering in Power BI Desktop, and under the option File -> Help -> About
Once installed the Java Client, we must configure the connection to the Oracle database, this is achieved by modifying the file TNSnames.ora (The file location depends on where you installed the Java Client, within the Client folder is under The path … \ client_1 \ Network \ Admin). Within the file we must specify the connection through the insertion of the following entries[ALIAS] =
(PROTOCOL = TCP)
(HOST = [HOST_NAME])
(PORT = [PORT])
(SERVER = DEDICATED)
(SERVICE_NAME = [SERVICE_NAME])
[ALIAS] = Name to use in the Connection string of data Source
[HOST_NAME] = Name or IP address of the server that contains the database
[PORT] = Port to use
[SERVICE_NAME] = Name Service server Database After the Configuration, we will be able to connect to the database from Power BI Desktop. To do this we must go to Get Data-> Oracle Database
To connect must enter the server IP followed by / [ALIAS] specified in the file TNSnames.ora .
Analogous to SQL we can specify a query to the database in the section Advanced options.
References To enter Power BI Web address https://app.powerbi.com At the moment there is only support for SQL Server 2012 and 2014, we are working on the integration with SQL 2016 To download the Java Client, go to: