topic Re: Convert an Excel file with VBA code and formula to Power BI or Power App in Developer

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

mshojaei — Thu, 12 May 2022 19:13:22 GMT

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 can fill the blank cells and then based on the entered data, some calculation will happen and dynamic rows will be generated. The file (.xls) includes some macros and formula to do the calculation.

Now, they want to see the opportunity of converting this excel tool to Power BI or Power App. I was wondering which of these two tools should I use? is there any way that we can import Macros/formula from excel to any of them? Can we make any integration between these tools?

In general, I am looking for the best approach to convert an Excel file to Power BI or Power App.

I will appreciate any help or suggestion.

Thanks,

Maryam

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

lbendlin — Fri, 13 May 2022 18:58:50 GMT

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).

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

AilleryO — Mon, 16 May 2022 15:23:56 GMT

Hi,

The Power App would be more to get the data (to be stored in SharePoint list, Excel file, ...)

and Power BI to analyze and display data already collected.
I do agree with @lbendlin , you need to come back to business need and rebuild a solution.