Anaplan Power BI Connector - One Tenant?
Hi Anaplanners. I'm really enjoying the new Power BI connector but I'm having trouble accessing all the tenants I have access to. For some reason only one shows up. Does anyone know why this might be? @MagaliP I know connectors is out of the extension universe but maybe you know someone I can work with?
I'm using the Power BI Desktop November 2020. Plenty of export actions in other tenants too, so I'm not sure why they don't show up.
Best Answers
-
1
-
@JaredDolich I think this has to do with the API V2 where you can only make calls to your default tenant as an added security measure. I am assuming the tenant that you can see there is your default?
When I ran into this in the past (not specifically for Power BI Connector), I had to have my clients create an email login for me and add me to their workspace using that login so that that was my default tenant. Then I had full access to their tenant using that login. I think Support can technically change your default too, but that is cumbersome, and by gaining access to a different tenant you are losing access to the one you can currently see, so that isn't ideal either.
1 -
I have posted your message internally for visibility 👍
1 -
@JaredDolich
As of now, the PowerBI connector only allows you to form connections from your default tenant.
Source: https://help.anaplan.com/e1cdf0b7-631f-4cd6-b4df-a5e0927e1ef8-Anaplan-Connector-Power-BI-Desktop
If you want to use another tenant you need to change your default tenant by sending a request to the support team which might not be the best idea for most cases.
Solutions Consultant
Yookwi Hwang2 -
I added this one to the idea exchange if anyone would like to upvote https://community.anaplan.com/t5/Idea-Exchange/Ability-to-access-multiple-tenants-with-Power-BI-Connector/idi-p/92917
2
Answers
-
@rob_marshall @yookwi_hwang @MagaliP @jasonblinn @jnoone
As always, thank you for the quick response. Looks like I'll need to stick with the default tenant. I assume that if I change the default tenant away from Columbus Consulting then they will no longer get credit as a partner for my work, so that's not really an option. I might also try adding a new email to my COE to see if that works.
The good news is that this connector works out of the box ( @jnoone reported an issue with having to use an MEZ file?) - Been running some unbelievable visualizations out of Power BI from data within Anaplan. To be honest, New UX has most of what I need but when I need to combine data that's in the data lake (not in Anaplan) it's a lot easier from Power BI. Hopefully, there will be a way to use a CA certificate at some point, but one step at at time!
Thanks for a great new tool, brilliant work!!
Jared
0 -
Thanks @jnoone I gave it my upvote! For now, I just created a new email and added it to the tenant I want. Works fine as a workaround but can only work with one tenant at a time.
0