Use PowerBI with ActiveX
I used to create some VBscript to make some automation in my Excel files or my PowerPoint files.
set app = createobject("Excel.Application")
set wb = app.workbooks.add
I would like to do the same kind of things with PowerBI.
- Open PowerBI Desktop.
- Open this application.
- Reload data.
- Make this selection.
- Copy this chart to clipboard as image.
- Export this table as CSV file.