Now we can publish this data to our Power BI site. You will now see in the space that a visualization will appear based on the Oracle data you chose. Then on the right are the fields you can show and present And as you can see when you select a certain table the data is previewed on the right. We are going to create a visualization using the “Mark.NFL” table. So now we can start creating a report with an Oracle dataset to Publish to the Power BI site and setup Scheduled Refresh. So if all this was entered correctly you should get a list of tables to choose data from such as below. Then when it prompts you for access type choose “Database” and type in the in the actual Oracle database credentials to access the database you want. So even though my Oracle server name is Oracle11gMG, all I need to connect to my Oracle server is the name “SPORTS”. As with most oracle type connections all you need for the server name is what is in the TNS.Names file we referenced earlier. Now here is where some people could get confused. Go ahead and choose the “Oracle Database” option then click “Connect”. Then once you clicked the “Get Data” option you get a list of all the data sources you can choose.
Go ahead and click on that so we can get started creating our data source Once the application opens up you should see a window that gives you an option to “Get Data”. Open the Power BI Desktop application Once the Desktop icon appears.
#Refresh option on db solo download#
Once you download you should see an icon on your desktop that looks like the one below: Go to your Power BI site and download Power BI Desktop Now that we know what our Oracle Service ID is from the TNSNames.ora file, we can go to Power BI Desktop and connect to the data we want from Oracle. In this case I found my Oracle Service Id to be “SPORTS”. On the client machine you are going to create your Oracle report from, make sure you have the correct Oracle Service ID setup as that will be the connection information you will need to connect to Oracle as your data source when creating a connection in Power BI Desktop.
#Refresh option on db solo how to#
So I am going to explain how to get Oracle data published from the Power BI desktop to the Power BI site. This got me thinking, what is the way to connect to Oracle using the Power BI Desktop and Power BI site? Had a Customer that was having issues connecting to his Oracle data source via Power BI Desktop and then publishing it to his Power BI site. Important considerations for connecting to data in Power BI Power BI is designed to work well with a variety of data sources including Oracle.
Connecting to data sources through Power BI is an easy way to get analytics and insights on data that is important to you.
0 kommentar(er)
