PG

I'm investigating PowerBI reports vs the ARIS Connect REST API in order to present key results for our model numbers, freshness, group hierarchy, model types &c. However, I'm getting stuck on generating and using the session key to do the actual REST queries. PostMan works fine with a POST query like http://aris.myorganization.com/umc/api/v1/tokens?tenant=default&name=admin&password=topsecret, but PowerBI Desktop keeps insisting that the query must be anonymous in order to POST. 

Could anyone share a working skeleton PowerBI report that works to retrieve any data? I can do manual refresh of the session keys if I absolutely must, but won't be able to publish reports for others that way. 

Added

I'm trying to setup an empty datasource with an M query as below, but PowerBI Desktop claims authentication fails, with no more details. I've tried clearing out file and global authentication settings for the data source, but the global settings for http://<arisserverURL>/umc/api/v2/tokens refuses to clear. Time to hit the PowerBI forums, I guess.

let
    ArisDatabaseURL = "http://<arisserverURL>/",
    KeyRequest = Json.FromValue([tenant="default", name="system", password="*******"]),
    KeyResponse = Web.Contents(ArisDatabaseURL & "umc/api/v2/tokens",
        [Content=KeyRequest]),
    KeyDoc = Json.Document(KeyResponse),
    ApiKey = KeyDoc{0}[token],
    Cookies = "accesstoken=" & ApiKey,
    Databases = Web.Contents(ArisDatabaseURL & "abs/databases", [Headers = [ Cookie = "accesstoken=" & Cookies]] )
in
    Databases
by Michel Bénard
Posted on Sat, 12/10/2022 - 16:08

Hi Pontus , look here ,may be it wille help you: Using Aris Rest API : a working example | ARIS BPM Community (ariscommunity.com)

My goal is to fetch from PowerBI  excel reports generated by Aris Scripts and stored in Aris Document Storage.

The first step was to understand how to use Aris Rest API , now I'll have to understand how to get data from Rest Sources in Power BI queries.

 

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock