Valid replacement for PowerPivot on using a MySql database for DataStore
<p><strong>Scenario</strong></p>

<p>I would definitely have to say that I am in no means an Excel Wizard. I do manage to run the application and BI side of things for my company. We have approximately 80 users utilizing PowerPivot through a MSSQL data warehouse. This data warehouse is a mess and being rebuilt currently, there is a likelihood that the rebuild will not be in MSSQL as most of our new development and ETL is in PostgreSQL and MySQL; there is a 90% chance this will be MySQL.</p>

<p><strong>Problem</strong></p>

<p>Given that scenario I am in a quandary on how I can handle the users currently utilizing PowerPivot. While I do not have a full understanding of the Microsoft Power* tools, I do know that the PowerPivot tool is semi-functional with MySQL. It does not have the ability to Select Tables due to the SQL query conventions, unfortunately this is a heavily used feature of our end users but I know that "Excel for MySQL" handles that part, but does it match what PowerPivot can do?</p>

<p><strong>Questions</strong></p>

<ol>
<li>What differences are there between PowerPivot and MySQL for Excel in
functionality and usage? </li>
<li>Are there other Excel tools that provide
the same sort of functionality as PowerPivot? </li>
<li>Does PowerQuery provide any functionality benefit when using MySQL vs. MSSQL</li>
</ol>