Anaplan-Power Bi Connection using Basic auth-Blank source

Hi,

I am trying to connect Anaplan & Power bi, I followed steps metioned on Anaplan community, but I was not able to see data in Power Bi.

In Anaplan I have created one test export action.

In Power bi I have entered below url

in next step, I'm using my Anaplan User name & Password associated with the models.

but I'm not seeing any data source

Which step I'm missing ?

Accepted answers

AlejandroGomez

Are you in the “visting” list or in the “internal” list of the tenant users?

Edit:

I have been running some testing with my own account and some of my colleages.

Once you create the connection from PowerBI to Anaplan, it seems you can only see the Models from the Workspaces within the Tenant where you are an Internal user (as opposed to Visiting)

For more details, I have access to certain Tenants throguh SSO and to others throug the BASIC connection.

In Tenants accessible through SSO I am “Visiting”, so I could not see anything at all, same as you:

Accessing through BASIC, I have acces to multiple Tenatns and Workspaces from different clients, but I can only be “Internal” in one Tenant at a Time. And that Tenant's models are the only one available in PowerBI.

This hypothesis has been tested with colleages who are “Internal” users in other tenants different than mine and seems to be true.

So, if you are in the “Internal” list of a Tenant you should see in the Navigation page of PowerBI the models from the workspaces within that Tenant. You do not need “Integration” or “Tenant Admin” roles for this.

All comments

AlejandroGomez

Hi @swapnil_J

it seems to me that you are mixing up the basic and the SSO authentications.

on this pic, you are using the Auth for SSO users:

as per extracted from the documentation:

Basic authentication

If you choose Basic authentication, enter the following URLs:

Anaplan API URL	`https://api.anaplan.com`
Anaplan Auth URL	`https://auth.anaplan.com`

SSO authentication

If you use SSO authentication, enter the following URLs:

Anaplan API URL	`https://api.anaplan.com`
Anaplan Auth URL	`https://us1a.app.anaplan.com`

whereas in the next step, when entering your credentials you are using the “Basic” option instead of the “Organsiational Account” one, which is the one meant to be used wiht SSO:

I hope this solves your issue.

Cheers,

Alex

swapnil_J

Hi Alex, I have tried with above urls as well but still I'm not seeing any workspace/models/exports.

Do I need to clear any cache or change anything in browser setting?

AlejandroGomez

I dont think so,

I have tried myself and, despite not finding any documentation about it yet, i believe your issue is caused by your permissions within your Anaplan tenant.

When I created a new connection to PowerBI myself, I can only see the data sources from the Anaplan Workspace and Tenant where I am “Integration Admin”.

You, or your Tenant Admin, can check this in “Administration”

Assignmnets

And then look for your account and permissions within your Anaplan tenant

Once you are granted the right permissions there, You should see the available models within your workspace in PowerBI

swapnil_J

Thanks for the inputs Alex.

I have page builder and WS Admin access but not integration Admin or Tenant Admin may be that not having these two access are causing this issue. If possible can you please try by removing this two access?

AlejandroGomez

Are you in the “visting” list or in the “internal” list of the tenant users?

Edit:

I have been running some testing with my own account and some of my colleages.

Once you create the connection from PowerBI to Anaplan, it seems you can only see the Models from the Workspaces within the Tenant where you are an Internal user (as opposed to Visiting)

For more details, I have access to certain Tenants throguh SSO and to others throug the BASIC connection.

In Tenants accessible through SSO I am “Visiting”, so I could not see anything at all, same as you:

This hypothesis has been tested with colleages who are “Internal” users in other tenants different than mine and seems to be true.

swapnil_J

Thanks a ton Alex!

I am part of visiting list, and may be that is the issue.

Thanks for the detail soultion.

AlejandroGomez

Happy to help!

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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.
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…