Stale Module Data in Power BI
I've successfully built out a Power BI semantic model that appears to connect to Anaplan just fine. When I created the model, I logged into the Anaplan Connector using my company SSO. Once the credentials were validated, I selected the Export Action that I had previously created and loaded the data. Initially, all data came through and the model appeared to be working perfectly.
However, after about a month, I've noticed the Anaplan Lists and Modules that I am loading into the Power BI model are stale. They contain the exact same data they contained when I initially created the connection. Power BI is not giving me any indications that the connection is defunct. There are no errors and the model refreshes successfully a couple times a day.
What is even more confusing is that when I attempt to create a new connection to Anaplan in a brand new Power BI file, the data that is loaded is the same stale data. It somehow seems that Power BI is not triggering the export action. Is there some sort of toggle setting within Anaplan that allows outside connections to trigger actions?
Answers
-
Hey Jeffrey,
I don't have any experience with this particular connector but there is no toggle setting on the Anaplan side to allow for outside connections. From the Anaplan perspective, a user is a user and it is somewhat irrelevant how the connection is being made (logging into Anaplan UX, calling an action via API, etc.).
As long as you are able to authenticate into Anaplan successfully and the user account being leveraged has a model role/access to run the export actions then the export action will execute.
To me the issue sounds like it is either within the connector itself (either configuration or an issue/bug) or something within the PBI configuration.
Let us know if you are able to get to the root cause!
-Tiffany
0 -
Hi Tiffany,
We ultimately did figure this out. The connection seems to require that the user whose credentials are being used for the connection has Full Access to the model. So any model permissions short of Full Access will result in stale tables.
We just recently changed the Power BI connection credentials from a human to an automation user's credentials and that seems to be working very smoothly!
Thanks for the follow up!
Jeff
1 -
Glad to hear you got it sorted!!
Just to cover the bases, for those export actions were the user roles in question setup to allow the exports to be run? Quick example below, in this instance only "Full Access" user would be able to run the export action but if you grant that permissions to the role then any user with that role should be able to run the action.
Might be a nuance of the PBI connector, but above is how you would typically allow non-Full Access users to run an export action.
0 -
Great, thank you! That's helpful information.
1