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.

Accepted answers

rob_marshall

@JaredDolich

Which tenant do you see? I have a theory.

Rob

jasonblinn

@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.

MagaliP

I have posted your message internally for visibility 👍

yookwi_hwang

@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 Hwang

jnoone

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

All comments

rob_marshall

@JaredDolich

Which tenant do you see? I have a theory.

Rob

jasonblinn

@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?

MagaliP

I have posted your message internally for visibility 👍

yookwi_hwang

JaredDolich

@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

jnoone

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

JaredDolich

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.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…