Install PowerBI

​@Ed22 

Setting up of Power BI Integration could be divided into two parts

• Power BI Cloud Integration with IFS Cloud Web
• Power BI Report Server Integration with IFS Cloud Web

https://docs.ifs.com/techdocs/24r1/050_reporting/400_iframe_int/010_setup_pbi_int/#power_bi_cloud_integration_with_ifs_cloud_web

What are you looking to configure?

IFS Documentation

Power BI Integration in IFS Cloud
IFS Cloud supports embedding Power BI reports and dashboards directly into the web client for advanced analytics. The process involves two main steps:

1. Set Up BI Infrastructure

   • If hosting BI infrastructure yourself, you need to configure resources in Microsoft Azure.
   • Two common scenarios:
     • Remote Customer Azure Cloud
     • Cloud Customer Azure Cloud
   • Estimated setup time: ~5 hours (including Azure configuration).
     Read Full Guide: BI Infrastructure Setup [docs.ifs.com]

2. Connect Power BI to IFS Cloud

   • Configure Power BI Report Server with HTTPS for secure connections.
   • Publish Power BI reports and embed them in IFS Cloud using the report URL.
   • Ensure prerequisites on Power BI side (workspace, datasets, gateway for refresh).
     Read Full Guide: Setup Power BI Integration [docs.ifs.com]

Key Points

• You do not install Power BI inside IFS Cloud; instead, you integrate Power BI services with IFS.
• Requires:
  • Power BI Pro or Premium license
  • Azure resources for BI infrastructure (if self-hosted)
  • HTTPS configuration for Power BI Report Server
• After setup, you can embed Power BI dashboards in Aurena pages for seamless analytics.

Community Insight

Users confirm that connecting Power BI to IFS Cloud often involves:

• Direct connection to the IFS database via Power BI Desktop
• Setting up a gateway for scheduled refresh
  Read Discussion: Access IFS Data from Power BI [community.ifs.com]

Hello, I installed PowerBI desktop and also Web, but I cant find this: https://docs.ifs.com/techdocs/24r1/050_reporting/400_iframe_int/010_setup_pbi_int/#steps_to_add_a_power_bicloud_report_to_ifs_cloud_web

​@Ed22 you need to publish the report from PBI Desktop to PBI service (web) in one of the workplaces you have access to.

Then in PBI Service/web you go go File - Embed

See more details in the Microsoft documentation:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure

Once you generated the link to be embedded in IFS Cloud, you go to Manage Reports and just past the link:

It doesnt matter what will be in this report?

​@Ed22 content doesn’t matetr. Of course the users that will view the report in IFS CLoud, must have access to the PBI Service as well. They will be required to login before seeing the PBI in IFS Cloud

Hi ​@Ed22, note that your documentation link above refers to 24R1 - is this what you’re using? The documentation explains embedding an entire report into IFS Cloud as an iFrame. There is a more modern approach (which also gives more licensing flexibility): Configuring Power BI Elements - Technical Documentation For IFS Cloud It embeds the report/report page/page visual into a lobby element, which can then be mixed with “normal” lobby elements in a lobby page.

Hello, I install it, but when I try to connect in oracle database, fill server field with informations from tnsnames.ora → typed HOST:PORT from tnsnames.oraI got this error: “It cant connect → ORA-12154:TNS. could not resolve the connect identifier specified. I created TNS_ADMIN in Environment variables, but nothing happen

​@Ed22 are you trying to connect your Power BI Desktop directly to the IFS/Oracle DB? You’ll need IFS to setup a VPN tunnel between the machine you’re running PBI Desktop and the Oracle DB machine.

Or alternatively, you could connect via HTTP and consume Quick Report data in PBI.

See an example of such a setup done by ​@dsj 

https://dsj23.me/2023/11/06/creating-an-api-proxy-for-ifs-cloud-using-azure-apim/

I’m not sure if you have already found a solution for this, but I wanted to share an approach I’ve implemented.

I built a custom Power BI connector that integrates directly with the exposed IFS Quick Reports API. The connector allows you to execute existing IFS Quick Reports and retrieve the results directly into Power BI.

This can be particularly useful if you already have Quick Reports that you run regularly, as you can use those existing reports as data sources for Power BI without having to recreate the underlying queries from scratch.

If you're interested, I’d be happy to share more details about how I built the connector and walk you through the setup.

LinkedIn: https://www.linkedin.com/in/prasiddha-neupane/