Skip to main content

Power BI

Needs Votes

VBA for Power BI Desktop

Vote (1280) Share
Anthony Newell's profile image

Anthony Newell on 06 Jun 2016 03:14:20

Ability to provide a custom UI for a user to enter some parameters / inputs prior to refreshing the data model and publishing to Power BI

Comments (173)
Anthony Newell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:05:57

RE: VBA for Power BI Desktop

Please integrate VBA in Power BI for automation!!!!!!

Anthony Newell's profile image Profile Picture

Yasser Tamer on 05 Jul 2020 23:05:53

RE: VBA for Power BI Desktop

It will make a huge difference.

Anthony Newell's profile image Profile Picture

Dr. John Hopkins on 05 Jul 2020 23:05:51

RE: VBA for Power BI Desktop

Absolutely. For flexibility and backward compatibilty, integrate VBA into Power BI.

Anthony Newell's profile image Profile Picture

Alin Gabriel Drăghici on 05 Jul 2020 23:04:50

RE: VBA for Power BI Desktop

VBA is love, VBA is life.

Anthony Newell's profile image Profile Picture

Gustavo Pittaluga on 05 Jul 2020 23:02:11

RE: VBA for Power BI Desktop

When can we voted to incorpórate VBA integration in Power BI?

Thanks in advanced.

Anthony Newell's profile image Profile Picture

Daniel Ahr on 05 Jul 2020 23:01:33

RE: VBA for Power BI Desktop

Yes.
I made a VB6 app that used Excel as a calculation engine hidden in the background.
An open Visual Basic library like in the Office suite would mean:

1.You could automate report generation as you would do via manual workflow in SSIS and SSAS for local Excel/tsv/csv files

2. You could also add button features in your reports that could switch between dark/bright themes in your report OR switch graphs with a click! Obviously any VB elements would have to publish to Power BI cloud to be useful!

A great advantage over your competition from Qlik/Tableau.

Phone app dev for IOS and Android has shown as well as power BI visuals; that the community will ALWAYS be able to come up with better ideas than Microsoft or any company might have the time for!

Anthony Newell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:00:46

RE: VBA for Power BI Desktop

Yes!!! Please, please, please, add VBA to the Power BI app !!!

Anthony Newell's profile image Profile Picture

Power BI User on 05 Jul 2020 22:58:13

RE: VBA for Power BI Desktop

Hi
We are using excel with macros for generating reports and display it in graphical format.
Can we use Power BI to do the same ?
Is it possible to do same and display graph and also can we generate excel output, graphs, multiplae tabs, in webpage?

Thanks

Anthony Newell's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:01

RE: VBA for Power BI Desktop

I am an advanced VBA developer, and am considering replacing TIBCO Spotfire with Power BI. Spotfire supports JavaScript, and apparently Power BI down NOT support VBA? Please add VBA to Power BI. It's a make or break for me.

Anthony Newell's profile image Profile Picture

Derron on 05 Jul 2020 22:56:26

RE: VBA for Power BI Desktop

This is a very useful BI tool. However, it would be more powerful and versatile with the integration of VBA.