Power BI

Needs Votes

VBA for Power BI Desktop

Vote (1280)

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)

Comments (173)

Chandler Shores on 14 Oct 2021 02:21:23

RE: VBA for Power BI Desktop

Yes, Vote for Power BI with VBA

on 22 Sep 2021 12:44:46

RE: VBA for Power BI Desktop

YES to VBA for Power BI, please

David Hines on 05 Jun 2021 14:48:05

RE: VBA for Power BI Desktop

I would like to have a PBI Add-In, tool, or control for use in MS Access that could be automated using VBA.

David Hines on 05 Jun 2021 14:44:46

RE: VBA for Power BI Desktop

I have a lot of National Fish Hatchery data (over 30 years) in MS Access and SharePoint lists. We use MS Access for data entry at 12 National Fish Hatcheries and currently store the data in an Access database file for each Hatchery since they have slightly different operations and requirements at each one. There are a lot of business rules and calculations in VBA code that would require a lot of work to reprogram in another software.

I currently have a Dashboard.pbix file for each hatchery database that is linked to the Access database backend and is opened in PBI Desktop from a button on a form using VBA shell code.
Private Sub cmdPBIDashboard_Click()
Dim Shex As Object
Set Shex = CreateObject("Shell.Application")
Shex.Open (Application.CurrentProject.Path & "\Dashboard.pbix")
End Sub

I would also like to use VBA in PBI to automate interactive reports. I would really like to have a PBI control (like the web browser or MS Graph control) or tile (like Power Apps) available to use inside MS Access on forms and reports. Or a PBI Add-In that could be customized using VBA.