Forum Discussion

mshojaei's avatar
mshojaei
New Member
4 years ago
Solved

Convert an Excel file with VBA code and formula to Power BI or Power App

Hello, I am a newbie in the Power BI and Power App worlds with very basic knowledge. There is an excel file in our organization that has different sheets and each sheet looks like a form that user ...
  • lbendlin's avatar
    4 years ago

    We generally recommend against attempting that.  The reason both VBA and Power Query exist is that they are different, both on a language level and also on a philosophical level. 

     

    Instead, formulate the business need that your current VBA is solving, and then solve the same business need with Power Query (or DAX) if appropriate.  (It is also possible that Power BI is not the right tool for your scenario).