Power Query - Get Data from Anaplan

I use Power Query within Excel to connect to online sources such as Salesforce. Is it possible to connect Power Query within Excel to Anaplan and how do I do this? I have seen an article about the Power BI connector but I cannot see a link to where I would download it from or whether I can use this with Power Query in Excel specifically. Thank you.

Accepted answers

All comments

JaredDolich

@kristenr

That is such an awesome idea. You can use Power Query to call an Anaplan API but you'll probably have to use Version 1 APIs and use basic authentication. When PowerBI first came out that's how everyone connected to Anaplan. Same way. Eventually, Anaplan developed the native integration for PowerBI. Perhaps we can convince Anaplan to also build the integration for Power Query.

The bottom line is that you can only get data in and out of Anaplan using their API. There's no other way. Even Salesforce, Anaplan Connect, Tableau, Alteryx, Informatica, Mulesoft, etc. they all use Anaplan's API. So for now that's how you can do it.

kristenr

Thanks Jared. Is there a link to instructions on how I would do this - ie call an Anaplan API?

JaredDolich

@kristenr

Nice! I just looked it up. Looks like you can use the same connector that PowerBI uses. What luck. Here's the link.

https://docs.microsoft.com/en-us/power-query/connectors/anaplan

It will help to be familiar with how Anaplan APIs work but this will get you started.

Also, keep in mind you will only be able to connect to your "default" workspace using this add-in.

Nicolas Cadier

@JaredDolich

Sorry to reply on an old thread! I'm looking to implement something very similar, a connection to Anaplan via Power Query in excel. (Anaplan add-in is not suitable as I need more than three dimensions in rows).

How did you leverage the Power BI connector in excel? I noticed that the connector used in Power BI (the Anaplan() function) was not recognised in Power Query excel.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…