Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

VBA for Power BI Desktop

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
Status: Needs Votes
Comments
olga_berstein
New Member
Can't agree more with the comment saying that VBA for Power BI is highly needed. Are there any plans in Microsoft for adding VBA to Power BI?
jim1rugg
New Member
Qlik and Tableau have had extensive UI programming for years, why can't PBi? Integrating VBA would completely blow away all competitors in an instant.
echozhang21
New Member
YES, VBA for POWER BI
binhtrinh19
New Member
Vote for VBA application in Power BI.
avishai115
New Member
VBA for Power BI is a must.
alex_wooldridge
New Member
Very useful if progressed!
ohuzan
New Member
VBA for PowerBI please
ahodges
New Member
Ability to push publications based on Excel or Outlook VBA triggers would be hugely helpful!
fbcideas_migusr
New Member
Please consider this
david_hines
New Member
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.