Push data into PowerBI - Realtime.

[mmascoli]

Hi Guys,

i have read several webpage - docs but as of now is not clear to me how to push data into PowerBI automatically.

I have create a dashboard where  my source is oracle client. After that i have publish my dashboard into the web with PowerBI 365. I desire to know from you what i need in order to have a "published" dashboard (so already present into the web with realtime informations.

What i need in order to close this gap?

I dont want to spend a lot of time and the dataset that now i refresh manually is less then 10.000 rows requested.

Thanks in advance for your help.

[Greg_Deckler]

Well, you could potentially use Direct Query (Live) connection if the Oracle connector allows it. Otherwise there is an API for pushing streaming data to Power BI. Take a look at the first one though because that is the easiest.

[mmascoli]

Hi Greg,

many thanks for your quick answer. What do you mean with Direct Query (LIve). Can you kindly suggest a link where i can setup oracle connector to allows Direct query (live) from PowerBI?

Thanks a lot,

[Greg_Deckler · Accepted solution]

When you connect to your Oracle database and put in the Server name, you should see a selection for "Data Connectivity mode" of either Import or DirectQuery.