Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
We have a corporate Power BI MIS, which is hosted on the Power BI cloud. When you log in it picks up your credentials from your PC so there's no actual login needed but you have to go through several access screens which validate you.
I'm trying to collect data from BI as the data has to go into Excel for annotation then into Powerpoint.
It's a bit archaic I know, pulling stuff of an MIS to make a powerpoint slide but that's how they do things here (I'm a humble contractor and organisational modernisation isn't in my contract
)
Can the authorisation be done in VBA? I've tried scraping the report using Internet Explorer (which pulls nothing back) and Xml (which throws an "Access is denied" error. Both use 'new' instances.
Assuming you can't do that, can you access an open instance of Explorer with VBA? So I open BI on Explorer. There's a host of drop down filters, which let me pick departments and teams, if I filtered the data it would be handy if Excel could access the current instance of Explorer to scrape the tables.
I'm trying to collect data from BI as the data has to go into Excel for annotation then into Powerpoint.
It's a bit archaic I know, pulling stuff of an MIS to make a powerpoint slide but that's how they do things here (I'm a humble contractor and organisational modernisation isn't in my contract
)Can the authorisation be done in VBA? I've tried scraping the report using Internet Explorer (which pulls nothing back) and Xml (which throws an "Access is denied" error. Both use 'new' instances.
Assuming you can't do that, can you access an open instance of Explorer with VBA? So I open BI on Explorer. There's a host of drop down filters, which let me pick departments and teams, if I filtered the data it would be handy if Excel could access the current instance of Explorer to scrape the tables.
