Power BI Pro
Does Action Pack provice Power BI Pro Licences ?
If not, does the o365 demo site offer the ability to prototype new Power BI Pro designs and functionality ?
Re: Power BI Pro
No, Power BI is not currently included in Action Pack (see https://partner.microsoft.com/en-us/membership/internal-use-software where you can open up an Excel spreadsheet).
Regarding your 2nd question, I'm unable to assist.