From Excel with VBA to PowerBI

[Anonymous]

Hello!

I'm new to PowerBI, and I did search the community and support for this topic but couldn't find anything relevant. Could you help please?

We have quite a few of Excel spreadsheets which are built on the principle that data is loaded from SQL server to them (through Connections), and then VBA script in excel analyzes this data and outputs the result. Then we use result in Spotfire just to visualize it nicely and have nice dashboard (not live). I'd like to get away from this and have everything in PowerBI, that would also help to make analysis live. What would be the easiest way to have VBA script set up in PowerBI? Is it even possible? I would want to avoid searching for the ways to do the same data analysis with PowerBI tools, if we already have VBA program written. Please advise! Any help is appreciated. Thank you,

Sabina

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Power BI Desktop is an entirely separate application from Excel and it has no VBA interface currently. Someone has submitted this feature request here: VBA for Power BI Desktop You can click to vote it up.

Regards,
Yuliana Gu

[ilcaa72]

no!  instead vote for Python to automate Power BI!!

[Greg_Deckler]

You cannot use VB script in Power BI,  you would have to rewrite it in DAX or M. You could potentially just replace Spotfire with Power BI for the visuals and keep the Excel pieces with their VB scripts.