Is this even possible?

[SH0lm3s]

Hello total newbie to Power BI, management have asked if I can use Power Bi to generate a sales actual and forecast report. That doesn't sound to hard, however they want to keep all the data each time that this is queried so they can see the changes in forecast and actuals. So the data will need to add a new cube of data each time (customer, finiancial time frame, actual sales, forecasted sales). 

Before I tie myself up in knots looking to see how I do this, thought it best to ask is it even possible?

Thanks Sarah

[Syndicate_Admin]

I would suggest to try BI Publisher Connector. Its the easiest way to directly connect Power BI to Oracle Fusion Cloud database (ERP, HCM, SCM, and CX). It also helps connect Power BI to the physical layers of OBIEE/OAC/OAS via OTBI data models and visualize data in minutes.

BI Publisher Connector is compatible with both Power BI Desktop and Service and all editions including Pro and Premium. It doesnt store any data anywhere, ensuring secure data connection between Power BI and Oracle.

Benefits

Hassle-free one-time set up

Error-free reporting & data visualization
Automate in Power BI Service

Time and cost savings

Hope this was useful.

[amitchandak]

@SH0lm3s , Based on what I got. You need near real time data. You can use direct query

There is some limitation in terms of database that are supported for that -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

Direct Query - End to End (Connection to Publish): https://youtu.be/cf-YNWX8Qow

[SH0lm3s]

Hi @amitchandak 

The information is in our ERP system which is oracle based, I know other companies that have our ERP application use Power Bi, however its how to keep data when you refresh as forecasts are currently changing daily

[AnalyticsFreak]

Hi @SH0lm3s ,

If you're looking to connect Power BI to Oracle Fusion ERP, BI Connector can help!

It connects to your Oracle ERP Subject Areas and Analysis Reports in minutes, and facilitates the blending of your ERP data with other data sources in Power BI. Works on both Power BI Desktop and Service, and supports both Import (with Scheduled Refresh) and Direct Query modes.

The connector is Power BI Certified, and retains the underlying joins between your Subject Area tables with simple steps.

Thanks,