# IFS Cloud Power BI Integration Using OData Projections > Source: https://netray.co/erp-help/ifs-cloud-power-bi-integration-premium-api-projections > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer The standard route from IFS Cloud to Power BI is the OData projection API, authenticated through IFS's identity provider with a service client. For heavy reporting, copy data to a warehouse or lake on a schedule instead of querying live from every refresh. ## Kind how-to ## System ifs ## Erp IFS Cloud ## Module Integration / OData Projections ## Query ifs cloud power bi integration ## Alternate Queries - ifs cloud premium api - ifs cloud power bi odata - connect power bi to ifs cloud ## Applies To IFS Cloud with projection OData endpoints. Power BI Desktop and Service, any licence tier; larger models may need Premium capacity on the Power BI side. ## Steps ### Connect Power BI to an IFS projection **Items:** - Find the projection and entity set you need using the OData explorer or the browser Network tab. - In IFS, create an IAM client for the integration and a service user with only the permission sets needed to read that projection. - Note the token endpoint of your IFS identity provider and the client id and secret. - In Power BI Desktop use Get Data > OData feed with the projection URL, or Web with a Power Query function that requests a token with the client credentials grant first. - Select only the columns you need and filter at the source with OData query options so the request stays small. - Publish, then configure scheduled refresh in the Power BI Service with a gateway if IFS is on-prem. - Test refresh duration and watch IFS performance. If it is heavy, move to a staged copy. ## Sections ### Authentication **Body:** IFS Cloud uses an OpenID Connect compatible identity provider. For unattended refresh you typically use a client credentials flow with a dedicated integration client rather than a person's password. Power Query can request the token and pass it as a bearer header. Keep the service user narrow. It should read the projections it needs and nothing else, which also gives you a clean audit trail. ### Shaping the query **Body:** Use OData options such as select, filter, top and orderby to limit data at the source. Pulling a wide entity with all columns for years of history is the usual cause of slow or failing refreshes. Page results correctly. Projections return pages, and a connector that does not follow the next link will quietly return only the first page, so verify row counts against the IFS list. **Code:** - GET /main/ifsapplications/projection/v1/.svc/?$select=Col1,Col2&$filter=OrderDate ge 2025-01-01&$top=1000 Authorization: Bearer ### Live query versus staged copy **Body:** Live OData is fine for small operational reports. For large history, many users or cross-system joins, load data nightly into a warehouse or lake and point Power BI at that. It protects the ERP and makes models faster. If the word premium in your question refers to Power BI Premium, that is about capacity and dataset size on the Power BI side, not an IFS licence. Check separately whether any IFS API access is licensed in your contract. ## Pitfalls - Using a named person's credentials for scheduled refresh. - Loading every column of a wide entity and years of history in one request. - Not following paging links and silently missing rows. - Pointing many report users directly at the live ERP during business hours. - Assuming Power BI Premium changes what IFS exposes. ## Ai Angle Where Power BI answers fixed questions, an assistant grounded in the same IFS projections handles the ad hoc ones in plain language and shows the query it ran. It can run on-prem against your own models, keeping ERP data inside your network. ## Faq ### Does IFS Cloud have a native Power BI connector? **Answer:** The dependable route is the OData projection API consumed through Power BI's OData or Web connectors. IFS also offers its own analytics tooling, so ask your IFS contact which options your licence includes. ### Why does my Power BI refresh return fewer rows than IFS? **Answer:** Usually paging, a filter, or the service user's data access being narrower than yours. Compare counts, check the next link handling and review the permission sets of the integration user. ### Can I connect to on-prem IFS? **Answer:** Yes, through an on-premises data gateway so the Power BI Service can reach the IFS endpoint from inside your network. ### Is a data warehouse necessary? **Answer:** Not for small reports. For large volumes, many users or joins to other systems, a staged copy is usually better. ## Search terms ifs cloud power bi integration, ifs cloud power bi, ifs cloud premium api, ifs cloud odata power bi, ifs projection api, connect power bi to ifs, ifs cloud reporting, ifs cloud data warehouse --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json