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

1b5dd262 3c6a-44ed-a4d2-74906e66a3de 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

b8ce24de 3463-4ea7-a1e0-7c83a22b2fcd 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

6a918d8a b21c-44fe-a63b-e8a25f2c4ecd 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

847192ad 0cf2-4b40-91ae-a9208ad4c084 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.

Anthony Newell's profile image Profile Picture

6163c5f7 207b-4649-975d-6caded42ef32 on 05 Jul 2020 22:55:39

RE: VBA for Power BI Desktop

Does PowerBI desktop have something like OLE automation, so we can automate like excel?
If yes , where can I find the information? I try a number of Power shell scrip in GitHub, not working at all, run with error

Anthony Newell's profile image Profile Picture

99cb76f9 a3fe-4f77-94da-c601b14d2c0f on 05 Jul 2020 22:52:26

RE: VBA for Power BI Desktop

Maybe the ability to create a tile where you can create all the functionality of an activex form (like Excel or MS Access forms).

Anthony Newell's profile image Profile Picture

ab72da01 e6cc-4ac4-acd2-170af4a9bc31 on 05 Jul 2020 22:43:07

RE: VBA for Power BI Desktop

Or, just automation of Power BI with VBA.