Chihiro
Excel Ninja
Can't believe I haven't seen this before.
https://docs.microsoft.com/en-us/power-bi/publisher-for-excel
From what I understand, this tool is available to Excel 2007 and up. Though it's fairly limited in who can connect to dataset, it can serve as additional tool in analysis work space.
Looks like it also works with free subscription of PowerBI (albeit with more limitations).
Can someone with non ProPlus license of Excel and free PowerBI subscription test if it works with that combo? I'd be really interested to see if measures works (just simple SUM, COUNTDISTINCT, etc).
https://docs.microsoft.com/en-us/power-bi/publisher-for-excel
From what I understand, this tool is available to Excel 2007 and up. Though it's fairly limited in who can connect to dataset, it can serve as additional tool in analysis work space.
Looks like it also works with free subscription of PowerBI (albeit with more limitations).
Can someone with non ProPlus license of Excel and free PowerBI subscription test if it works with that combo? I'd be really interested to see if measures works (just simple SUM, COUNTDISTINCT, etc).