Anaplan Power BI Connector - One Tenant?

JaredDolich
Moderator

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.

PowerBI_Connector.png


Jared Dolich
5 ACCEPTED SOLUTIONS

Accepted Solutions
rob_marshall
Moderator

Re: Anaplan Power BI Connector - One Tenant?

@JaredDolich 

 

Which tenant do you see?  I have a theory.

 

Rob

View solution in original post

jasonblinn
Master Anaplanner/Community Boss

Re: Anaplan Power BI Connector - One Tenant?

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

View solution in original post

MagaliP
Community Boss

Re: Anaplan Power BI Connector - One Tenant?

I have posted your message internally for visibility 👍

Magali Pelissier, Product Manager - Extensions (Excel Add-in, PowerPoint Add-in, Google Sheets Add-on)
Check out our dedicated Community page in the Platform section!

View solution in original post

yookwi_hwang
Occasional Contributor

Re: Anaplan Power BI Connector - One Tenant?

@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 

View solution in original post

jnoone
Certified Master Anaplanner

Re: Anaplan Power BI Connector - One Tenant?

7 REPLIES 7
rob_marshall
Moderator

Re: Anaplan Power BI Connector - One Tenant?

@JaredDolich 

 

Which tenant do you see?  I have a theory.

 

Rob

View solution in original post

jasonblinn
Master Anaplanner/Community Boss

Re: Anaplan Power BI Connector - One Tenant?

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

View solution in original post

MagaliP
Community Boss

Re: Anaplan Power BI Connector - One Tenant?

I have posted your message internally for visibility 👍

Magali Pelissier, Product Manager - Extensions (Excel Add-in, PowerPoint Add-in, Google Sheets Add-on)
Check out our dedicated Community page in the Platform section!

View solution in original post

yookwi_hwang
Occasional Contributor

Re: Anaplan Power BI Connector - One Tenant?

@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 

View solution in original post

JaredDolich
Moderator

Re: Anaplan Power BI Connector - One Tenant?

@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

 


Jared Dolich
jnoone
Certified Master Anaplanner

Re: Anaplan Power BI Connector - One Tenant?

JaredDolich
Moderator

Re: Anaplan Power BI Connector - One Tenant?

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.


Jared Dolich