Anaplan-Excel Power Query Connector
Currently, Anaplan supports connecting to Power BI via the Microsoft Power Query function
- https://help.anaplan.com/e1cdf0b7-631f-4cd6-b4df-a5e0927e1ef8-Anaplan-Connector-Power-BI-Desktop
- https://learn.microsoft.com/en-us/power-query/connectors/anaplan
It would be extremely useful if Anaplan supported connecting to the Microsoft Excel Power Query editor as well. After reading this articles I reached out to support to confirm if this is possible - it is not.
While the Anaplan Excel Add-In is useful, this connection would provide additional functionality that it does not provide. From my perspective, this would greatly streamline regression analysis of Anaplan models against legacy models as both data sources could be combined into the same saved Query rather than having to be compared across several sheets.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!