Forum Discussion

SH0lm3s's avatar
SH0lm3s
Frequent Visitor
4 years ago

Is this even possible?

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 tim...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    SH0lm3s
    Frequent Visitor
    4 years ago

    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's avatar
      AnalyticsFreak
      Icon for Helper I rankHelper I
      3 years ago

      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,