Stay tuned for more news on our blog and subscribe to our newsletter if you want to receive our new posts in your mail, get course discounts… 🙂 ¡Feel free to enroll in it and enjoy learning! If you want to improve your knowledge in Power BI, you can check out our course. In conclusion, this is the way to connect Power BI from Oracle Database. Now, in the right part of the screen, we can see the loaded tables with all their data. If we click on some of them, we will able to load them in Power BI Desktop, as follows:Īfter a few minutes of loading, the tables selected will appear: If you click on your schema (in our case, EXAMPLE_USER), we will see the same databases we have in Oracle. Therefore, you will be able to see the objects you have in your Oracle database: Once you click on the Connect button, you will arrive at the following window. So here, in our case, we have to introduce the following credentials: Here we have to write our credentials and these credentials correspond to the user we created in the Oracle Database Express Edition 11g program: Once we have all this right, we click on OK button.Īfter that, the following window will appear. Once we have copied and pasted the text before, we have to ensure that the Import option is selected because we want to import directly the data from an Oracle database. Note: if you do not have exactly that code, change it to get it in the same way! These instructions are written in the tnsnames.ora file, which is located in: C:oraclexeapporacleproduct11.2.0servernetworkADMIN (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))) In the Server box, we will write the exactly the following text: How to connect Power BI to Oracle DatabaseĪfter click on Connect button, the following window will appear: As we want to obtain the data from an Oracle Database, the only thing we have to do is to mark that Oracle Database option and click on the Connect button. When you open Power BI Desktop, you will see the following window:īy clicking on Get Data (located at the top left of the window), the following window will appear. So,in this post, I will walk you through the process to get data in Power BI from Oracle Database. Microsoft’s Business Analytics Service Power BI, enables us to connect to hundreds of data sources and produce beautiful reports that can be consumed on the web and across mobile devices, in order to deliver insights throughout our entire organization.
0 kommentar(er)
