2/12/2023 0 Comments Aws oracle databaseNote: 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |