Forum Discussion
mshojaei
4 years agoNew Member
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 ...
- 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).