Forum Discussion

Dinaveth's avatar
Dinaveth
New Member
4 years ago
Solved

Power BI and Excel

Dear Powe BI Team,

 

I am using power bi to extrat some information from an oracle database and I am modeling the information un power query. But I want to add a "notes" columnm this notes are manually inserted and comes from an excel sheet.

To avoid using Power Bi to obtain the information fron the oracle data base and use excel to obtain my comments data, I want to have the power bi report in excel in the same file where I have my notes is there other option besides copy and paste the power bi table every time?

  • Good point, I think I found an aceptable solution so I will accept this as an answer 😁 thank you for replying 🙂

4 Replies

  • Read about the "Analyze in Excel" feature of Power BI.

     

    On an unrelated note - What do you need Power BI for when you could connect to your Oracle db directly from Excel?

  • Thank you for your answer, it is easer to transform the data in PBI and a dashboard will be created with this information.

     

    • lbendlin's avatar
      lbendlin
      Super User

      I would challenge that, especially when you talk about adding annotations to the data. Power BI is still rather bad at that.

      • Dinaveth's avatar
        Dinaveth
        New Member

        Good point, I think I found an aceptable solution so I will accept this as an answer 😁 thank you for replying 🙂