Power BI connection using basic authentication

[Shawnm]

What are the steps involved to establish a connection from anaplan to Power BI using basic authentication?

[Akhtar.shahbaz]

Hi @Shawnm 

You can refer below link for Power Bi connector, @JaredDolich  has explained step by step very nicely. I am sure below link helps you a lot and it's good to start to explore Power BI connector.

https://community.anaplan.com/t5/Anaplan-Platform/Integrate-Anaplan-in-Power-BI/td-p/35003/page/2

Thanks

Akhtar

[JaredDolich · Accepted solution]

Hi @Shawnm 

@Akhtar.shahbaz is correct. You can follow the instructions on the link he provide OR you can use the fancy new native connecter which was just released.

https://community.anaplan.com/t5/Releases/Announcing-the-Anaplan-Connector-for-Power-BI/ba-p/89942

[Shawnm]

Thank you for your reply. I'm sorry but I got one more doubt, is it also possible to export data back from Power BI to Anaplan using this connector? I tried the new Anaplan connector( beta) and was able to run an export from Anaplan to Power BI, I'm just wondering if the opposite is possible too.

[JaredDolich]

@Akhtar.shahbaz 

The short answer is not yet. The Power BI connector is one-way for now. Depending on what you're trying to do, you might also look at the Anaplan Excel Add-In as an alternative to Power BI. From Excel you can send data back with the connector. It's amazing.