Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
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.
Thanks,
Hemanth
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
Michael
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: https://ideas.powerbi.com/forums/265200 .
Thanks,
Lydia Zhang
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
12 | |
9 |