web
You’re offline. This is a read only version of the page.
close
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.