How to access to IFS data from POWER BI

Information Sources are used as a basis for transferring information to separate BI and analysis tools

That is said about Information Sources in the cloud 22R1 documentation. I haven’t found a practical way to do it yet though.

https://docs.ifs.com/ifsclouddocs/22r1/DocBusinessIntelligence/AboutInformationSources.htm

Have you actually been able to connect from Power BI but cannot retrieve any data?

I haven’t used IFS Cloud yet, but have connected Power BI to both on prem and AWS IFS instances. Should be possible just the same. If you can connect to the Oracle DB for IFS cloud from your machine, then you can connect Power BI desktop to it. Just have to set up a gateway to refresh the data after that, to get it up to Power BI Cloud.

Setting up Oracle connection correctly can be a pain. Have to use Power BI desktop from the Microsoft website, not the one from the windows store, that one won’t work with Oracle. Then make sure Have all Oracle client stuff installed, I usually do the admin client. Even then Power BI will wrongfully throw an error saying you need the client installed even though do already, just keep going anyway and it will work.

Hi Christophe,

Did you find an easy way to link Power BI with IFS ? 

Isn’t this handled through the BI module, to an in-between MS SQL server to reduce strain on the Oracle DB? These are delivered for Apps10 customers.

The instructions seem to exist in Cloud docs also:
https://docs.ifs.com/techdocs/22r1/070_remote_deploy/400_installation_options/007_br_and_a/

Hi all,

You can request a quick report with a IAM user connected to a service user , if the user is allowed to access the quick report.
I use two requests.

request 1 named GetToken :

= () =>
let
    url = "https://*******.ifs.cloud/auth/realms/sessprd1/protocol/openid-connect/token",
    body = "grant_type=client_credentials&scope=openid&client_id=IAM_user&client_secret=***********",
    Source = Json.Document(Web.Contents(
        url,
        [
            Content = Text.ToBinary(body),
            Headers = [
                #"Content-Type" = "application/x-www-form-urlencoded"
            ]
        ]
    ))
in
    Source

request 2 :

= let
    tokenResponse = GetToken(),
    accessToken = tokenResponse[access_token],

    
    apiUrl = "https://*******.ifs.cloud/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_123456()",
    rawResponse = Json.Document(Web.Contents(apiUrl,
        [
            Headers = [
                #"Authorization" = "Bearer " & accessToken,
                #"Accept" = "application/json"
            ]
        ])),

    
    dataList = if rawResponse is list then rawResponse else rawResponse[value],

   
    table = Table.FromList(dataList, Record.ToTable, {"Name", "Value"}), 
    table2 = Table.FromRecords(dataList)

in
    table2

If you know how to use end user credentials, please share.

Regards,
Mickaël