Skip to main content

Power BI

Needs Votes

VBA for Power BI Desktop

Vote (940) 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 (157)
Anthony Newell's profile image Profile Picture

1b1e530e 5d14-4eb4-91ff-d260e21e462d on 05 Jul 2020 23:08:48

RE: VBA for Power BI Desktop

vba or c# support would allow a two way conversation with the data.
Very good. Can do this in Cognos. Would like to do it in PowerBI

Anthony Newell's profile image Profile Picture

d86f8c22 c2bf-480f-8de2-4eb511b65322 on 05 Jul 2020 23:08:27

RE: VBA for Power BI Desktop

please add vba support for PoweBI

Anthony Newell's profile image Profile Picture

d7f9003d 1591-4356-a739-3b81607edc03 on 05 Jul 2020 23:07:39

RE: VBA for Power BI Desktop

It would be an excellent addition to Power BI.

Anthony Newell's profile image Profile Picture

b3650b46 d99e-4f90-b6dd-17253ef71b45 on 05 Jul 2020 23:06:46

RE: VBA for Power BI Desktop

please add vba support for PoweBI

Anthony Newell's profile image Profile Picture

178326a3 b2ef-4725-8f52-bbcacb3329e7 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

5a27b3ff 6dec-4878-a981-b0482a0ae62f 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

dfec696f ae6e-4975-8ef6-5f016a7aa334 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

fb30dafc 3199-4fd4-b93b-b23a89a0e5d5 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

f7bd81e3 82be-4ace-bfa9-69ecbe523aaf 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

f2aec2e4 aef8-49b3-b53e-fdf4aeaf4f0e 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!