Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

New Member

Integration with IFS Apps 9 ERP



Has anyone integrated Power BI Apps with IFS APPS 9 ERP. Lot of companies seem to be using this ERP and it would be good to have a connector for the same.





New Member

Hi everybody,

I was an employee in the years 1999 to 2001 and responsible for the "IFS BI".
In these times IFS promoted Cognos (series 7). Later on - now self employed - I did a lot of
MS SQL Server based BI projects (most of them on Navision and Axapta).
Since 2 years we are back on the IFS track.
The customer we are working 70% our time with use PowerBI.
We tested different scenarios:
Using the "onboard IFS BI": very, very complex (over 700 SSIS packages) but shallow in main dimensions like customer or item.
Building a seperate DWH structure:
IFS does have round about 6000 tables and 6000 views.
Extracting, transforming and filling into cubes solved a lot of specifications.
We created multi-dim and tabulare cubes.

Because of the need of often more than 20 columns in a list like PBI report we quickly faced performace issues.

So additional datamarts in an extra DWH_PBI solved that.

Just for fun, we connected PBI directly with ORACLE Views/Tables.
This is technical not a problem at all but you have to have a strategy to handle the ever increasing complexity.
So the answer is: it depends!
PBI is a great tool with an interesting future. But you have to take care about business needs, the related complexity and performance issues.
Looking forward to hear more about that question!
best regards


Hi @hemanth,

There is no built-in connector for IFS APPS 9 ERP in Power BI. You would need to determine if the ERP system has OData feeds available or what is the database behind it, it is possible to connect straight to the OData feeds or the database from Power BI Desktop.

If none of the above methods help, please submit an idea in the Power BI Ideas forum: .

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors