Integrate Anaplan in Power BI

ABerenguela
Frequent Contributor

Re: Integrate Anaplan in Power BI

Hello,

 

try this format, it works for me:

 

url = "https://api.anaplan.com:443/1/3/workspaces/workspaces/workid/models/modelid/exports/116000000002/tasks",

header= [#"Authorization" = auth_key,

#"Content-Type" = "application/json"],

body1= "

{

""localeName"" : ""en_US""

}

",

data1 = Web.Contents(url, [Headers=header,Content = Text.ToBinary(body1)]),

 

Regards

 

 

 

CommunityMember116919
Occasional Contributor

Re: Integrate Anaplan in Power BI

@ABerenguela 

 

Port 443 did the trick, thanks for the insight.

shrey
Contributor

Re: Integrate Anaplan in Power BI

Hi Jared,

 

Great solution! Can this be done using authentication via certificate?

JaredDolich
Moderator

Re: Integrate Anaplan in Power BI

@shrey 

Yes, but I recommend you watch this video from TekLink on YouTube. You'll need to register but it's free.

https://www.teklink.com/webinar/analytics-with-a-custom-built-connector/?passkey=afbf9a7cc95391253f8...

It's a little more work than my example but TekLink's solution is much more scalable and reliable. Truly, they did a great job - presenter, Mario Arias, gives you everything you need to build a custom connector to PowerBI.


Jared Dolich
shrey
Contributor

Re: Integrate Anaplan in Power BI

This was great! I will look at the video!
alexpavel
Certified Master Anaplanner

Re: Integrate Anaplan in Power BI

@shrey take a look to this:

 

https://community.anaplan.com/t5/Best-Practices/How-to-Create-Connection-Between-Anaplan-and-Power-B...

 

It is exemplified how to use Certificate authentication in the attached file  "API_Anaplan-PowerBI.txt" of the article. 

 

 

 

shrey
Contributor

Re: Integrate Anaplan in Power BI

This is brilliant! Thank you for the response!
qsong1
Occasional Contributor

Re: Integrate Anaplan in Power BI

Hi @JaredDolich 

 

I used your method to connect with power BI, but i got the data with strange signs such as �, &,@ and all in one column. The data is in excel format in my export action. Do I miss anything?

 

Thank you

 

Best, Qianru

JaredDolich
Moderator

Re: Integrate Anaplan in Power BI

@qsong1 

Excel is encoded with all kinds of special characters for Microsoft to interpret the file. Give CSV a try. Also, make sure your line items show up as columns without any other dimension nested. Rows should be your lists.

Lastly, if you have time, try using some of the longer term suggestions I provided you.


Jared Dolich
jedwards
New Contributor

Re: Integrate Anaplan in Power BI

Additional option to consider if you do not currently have an ETL/iPaaS tool and don't want to do the technical heavy-lifting:

 

https://www.onecloud.io/

  • OneCloud, modern iPaaS tool and the most straight-forward method I've seen to connect Anaplan and Power BI