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)
RE: VBA for Power BI Desktop
VBA for all Microsoft products
RE: VBA for Power BI Desktop
Please, we beg for VBA on PowerBI Desktop
RE: VBA for Power BI Desktop
Yes, update Power BI with VBA
RE: VBA for Power BI Desktop
Every reasonably sized reporting solution I have ever worked on has had large components of code generated from metadata via scripts. For example, BIML, dynamic SQL or powershell to generate data staging tables and ETL processes. Now more of that work is moving into Power BI, being able to script the solution and not hand code dozens/hundreds of tables that all follow the same pattern can be the difference between a working enterprise solution and a manual mess. VBA for PowerBI, similar to what is already available for PowerPivot in Excel, would be great step forward.
RE: VBA for Power BI Desktop
I could be C# or Javascript.
RE: VBA for Power BI Desktop
I think we should be clear here what we are after:A. VBA in PowerBiB. VBA/External clients ability to control/automate PowerBI (I.E. PowerBI hosting a COM server and exposes a type library)I think most requests above are calling for Option B, which really has little to do with VBA.In such a case, we'd really be looking for 4 things:MVP A PowerBI type libraryMVP Ability to create instances of PowerBI from ProgID --> CreateObject("Power.BI.Application")MVP Ability to open and run PowerBi PBIX filesMVP Ability to add custom connections via a DISP interface.Nice to have: Ability to access and add datasets to a report (maybe as pure-dax)Nice to have: Ability to change the dax of existing reportsHere's an example of what I'd suggest:Dim obj as PowerBI.Application: set obj = CreateObject("Power.BI.Application")
Dim report as PowerBI.Report: set report = obj.open("my/file.pbix")
Dim customConn as object: set customConn = new MyCustomConnection
With report
.connectors.add(customConn)
With .queries.createQuery("myQueryName")
.dax = "..."
end with
.save
.refresh
Dim vData: vData = .queries.data
End With
RE: VBA for Power BI Desktop
No doubt, is a feature too much required.
RE: VBA for Power BI Desktop
Please implement
RE: VBA for Power BI Desktop
Please VBA for Power BI
RE: VBA for Power BI Desktop
VBA should be supported in all Microsoft Apps, including Power BI