Forum Discussion

Nagarjunav's avatar
Nagarjunav
Frequent Visitor
8 years ago
Solved

Change Data Source from Excel file to Oracle Database

Hi Friends

 

How would i change the data source from Excel file to Oracle Database?

 

I have some data in excel & i took it to the Power BI and created some report (Using some formulas, Graphs & Measures )

 

Now i want to import the data from Oracle and want to apply the same Template

 

I found one route i.e.

 

By dumping the data to excel and Changing the source Excel data

 

I Don't want this solution

 

I shall able to change the data source from excel to Oracle Database

 

Is this Possible in Power BI?

 

 

Thanks in Advance

Regards

Nagarjuna 

 

 

Need Help

3 Replies

  • BeemsC's avatar
    BeemsC
    Resolver III
    8 years ago

    Hey,

    I might've misunderstoond, but why dont you just directly get your data from the Oracle database.
    Just hold your report next to the new one and copy the steps you've applied.

    • Nagarjunav's avatar
      Nagarjunav
      Frequent Visitor
      8 years ago

      Hi BeemsC

       

      Thanks for your reply

       

      But i don't want to copy steps. Why because next time my source may change, like Oracle to Azure or Oracle to R Script Etc. Each time i shouldn't do it.

       

      Please let me know if you have any other Solution

       

      Thank you

      Regards

      Nagarjuna