Anaplan Connection - Invalid Credential

Hello team,

We are getting an error frequently, almost daily baysis, related to "invalid credentials" between Anaplan connection and Power BI Desktop.

Every time that team (two developers analyst) needs to work with the data, we need to reset the password and we are worried about this for the future.

Do you know if this could be related with any particular setup into PBI desktop environment?

In addition, the standard URL's below are already being used.

https://api.anaplan.com

https://auth.anaplan.com

Thank you

Marco

Accepted answers

JaredDolich

@areismarc

Just curious if both of these developers are trying to use the same ID. I'm not aware of any contention issues but perhaps this is what might be causing the issue. Also, you may need to clear the Power BI cache - sometimes the authentication gets stuck. Clear cache within Power BI (File>options>clear cache)

The only issue I'm aware of is that the "default" tenant for the ID is the only tenant that can be accessed but that sounds unrelated to what you're dealing with.

Here are some other common issues with Power BI connector.

All comments

JaredDolich

@areismarc

The only issue I'm aware of is that the "default" tenant for the ID is the only tenant that can be accessed but that sounds unrelated to what you're dealing with.

Here are some other common issues with Power BI connector.

Marina Ketelslegers

I have the same issue as you and it doesn't solve if I clear cache. Only password reset from Anaplan let the connector work (daily password reset). Is it a common issue? are there any other ways apart from clearing cache?

achoice13

I am having the same issues. Clearing cache does not resolve the problem. Here is a more in-depth overview of the potential issue - https://community.powerbi.com/t5/Issues/PoweBI-giving-Invalid-Credentials-with-Anaplan-Connector/idi-p/1445550

Is there a way for this to be resolved? This issue is essentially rendering the connector useless, unless developers want to continually reset their passwords.

BenGee

I've also been informed that some of our users are struggling with this issue, hopefully soon the SSO will work through PBI???

JohnnyC

The connector for Anaplan Single-Sign On (SSO) user is currently available, only if you have SSO enabled in your organisation environment.

I would say this is a good article for the steps to walk through. Hopefully this helps.

https://learn.microsoft.com/en-us/power-query/connectors/anaplan

JohnnyC

For Users with only Basic authentication, please see if the following steps work for you:

NOTE: User must NOT close Power BI until all steps are complete.

Open Power BI
Open Browser. Re-activate the user by going to anaplan.com > Login > Forgot Password
Once user re-activated, switch back to Power BI. Go to File > Options and settings > Data source settings > Edit permissions > Update credential to latest password. Refrain from refreshing before updating credential as you may get locked up again.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
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…
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…