Hi,
We use IFS Cloud 21.2.11 on Managed Cloud and Power BI desktop connect to Power Bi Cloud.
Is it possible to read IFS data from Power BI ?
If yes, do you have a documentation ?
Regards, Christophe
Best answer by Marcel.Ausan
View original
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?
+3
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.
+2
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/
Userlevel 6
+15
A step by step guide is available below. It even describes all the Azure resources that need to be created.
https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/
Furthermore there are even some predefined Power BI dashboards for pretty much every module. Of course, in order to open the pbix files from below link, the analysis models need to be setup.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.