How to connect Power BI to Priority ERP
Short answer
Power BI can read Priority through its OData feed, through a reporting copy of the SQL Server database, or through a data warehouse that you load on a schedule. For on-prem Priority, use an on-premises data gateway for refresh.
Priority has its own reports and dashboards, and for many questions they are enough. Teams reach for Power BI when they need to combine Priority with other data, such as machine data, CRM or budgets, or when management wants a consistent design across the company.
There are three ways to feed it, and the right one depends on volume and on how much load your Priority server can take. The OData feed is the simplest to set up. A reporting database copy is faster for large tables. A warehouse is the best when many reports share the same cleaned data.
The technical connection is the easy part. The harder part is deciding the definitions: what counts as on-time delivery, how scrap is measured, which date is the order date. Settle those before building visuals.
What teams use it for
On-time delivery and order backlog
Track promised versus shipped dates by customer, product group and plant, with backlog aging by week.
Inventory and turns
Show stock value by warehouse, slow-moving parts and coverage in days, combined with open purchase order receipts.
Purchasing performance
Supplier delivery reliability, price variance versus last receipt and open commitments by buyer.
Production status and WIP
Work order progress, scrap and yield, and WIP value by routing step, depending on how your shop reports in Priority.
Finance views
Receivables aging, margin by customer or product, and month-end comparison to budget alongside external data.
Priority ERP integration surface
- The Priority OData v4 service can be consumed from Power BI as an OData feed. It is simple, respects Priority logic and permissions, and suits moderate data volumes.
- On self-hosted installations, the underlying SQL Server database can be read for reporting, typically from a replica or restored copy to protect production. Table and column names are Priority specific, so map them carefully and check with your vendor on supported practices.
- Priority forms and reports can be exported to Excel or CSV, which supports small or ad hoc dashboards without any live connection.
- A data warehouse or lakehouse loaded by scheduled extracts is a common choice when several tools share the same data.
- The on-premises data gateway lets Power BI service refresh from a server that is not exposed to the internet. Details depend on your network and licensing.
How it works
- 1
Agree on the definitions
Write down each measure with its source fields and filters. Have operations and finance sign off before any build.
- 2
Choose the connection
Use OData for a pilot and small volumes. Move to a reporting copy or warehouse when refresh times grow or when the feed slows users down.
- 3
Install the gateway if needed
For on-prem Priority, install the on-premises data gateway on a server that can reach the data source, and register the data source in the Power BI service.
- 4
Model the data
Build a star schema with a date table, customers, parts, suppliers and facts for orders, receipts and stock. Do the joins in the model, not in every report.
- 5
Build and secure reports
Create the dashboards, and apply row-level security by plant, sales region or business unit where needed.
- 6
Schedule refresh and monitor
Set refresh times outside peak order entry, alert on failures, and track load on the Priority server.
Example flows
Daily backlog dashboard
Trigger: Scheduled refresh at 05:00
- Gateway queries order lines and shipments from the reporting source.
- Model computes open quantity and aging buckets.
- Dashboard shows backlog by customer and week.
Result: Sales and planning start the day with the same numbers.
Supplier reliability review
Trigger: Monthly procurement meeting
- Report joins purchase order lines with goods receipts.
- Measure compares promised and actual receipt dates.
- Visual ranks suppliers by lateness and value.
Result: Buyers see which suppliers need escalation, with the data behind the ranking.
Keeping data on-prem
With a self-hosted Priority server, keep the data inside your network and let the Power BI service refresh through the on-premises gateway, or use Power BI Report Server where your licensing allows a fully internal setup. Read from a reporting copy rather than production for heavy models. If natural-language Q&A is wanted without sending data outside, a local model that translates questions into queries over the same reporting layer is an option, with the answers shown beside the dashboards.
Security checklist
- Use a read-only account for the Power BI connection, and avoid personal credentials in shared datasets.
- Apply row-level security for plants, regions or customers, and test it with real user accounts.
- Restrict the gateway server and keep it patched, since it holds data source credentials.
- Review sharing settings so reports with margins or prices are not published to wide audiences.
Ways to get it done
Priority's built-in reports and dashboards
Effort: Low
Enough for single-system views and operational lists. No extra tooling.
Power BI over OData or a reporting copy
Effort: Two to six weeks for a first set
Good for cross-source dashboards where you own a BI developer or analyst.
Warehouse plus Power BI plus natural-language Q&A, with Netray
Effort: Scoped project
Fits larger estates where several systems feed the same views and users want to ask questions in plain language.
Pitfalls
- !Pulling large tables through OData repeatedly and slowing the production Priority server.
- !Building measures separately in each report, so numbers differ between dashboards.
- !Forgetting time zones and fiscal calendars in the date logic.
- !Querying SQL tables directly without understanding which fields Priority maintains through triggers.
- !Giving everyone access to cost and margin data by default.
Frequently asked questions
Does Priority have a Power BI connector?
Power BI can read the Priority OData feed using its standard OData connector. Check with Priority or your partner for any packaged connector or templates for your version, since availability varies.
Should I connect directly to the SQL database?
Only through a reporting copy, and only if your support terms allow it. Direct reads can be faster for big tables, but you must handle Priority's table structure yourself and avoid loading production.
Do I need a gateway?
If Priority is self-hosted and not reachable from the Power BI service, yes. The on-premises data gateway lets scheduled refresh work without exposing the server. Cloud-hosted Priority may not need one.
Can users ask questions in plain language?
Power BI offers its own natural-language features depending on licence and settings. For richer, grounded Q&A over ERP data on-prem, a local model over the same semantic layer is an alternative.
How often can data refresh?
It depends on volume, license limits and the load Priority can bear. Daily or several times a day is common. Near real time usually needs a different design, such as streaming or direct queries to a replica.
Want Power BI working on your Priority ERP?
A free 30 minute assessment: we map the integration path for your version and setup, and where it should run.
Get a free assessmentTry it here, free
Priority ERP OData REST URL Builder
Build Priority ERP OData URLs with host, tenant, company, entity, $filter, $select, $expand and $top, ready to paste into a REST client.
Keep exploring
Free tools
- Priority ERP OData REST URL BuilderBuild Priority ERP OData URLs with host, tenant, company, entity, $filter, $select, $expand and $top, ready to paste into a REST client.
- Priority ERP Form Design TemplateA fill-in design document for a new or changed Priority form: identity, columns, triggers, privileges, sub-forms and test cases.
- SyteLine Reporting and BI Maturity AssessmentA short assessment that scores how reliably SyteLine data reaches reports, dashboards and decision makers.
ERP fixes and how-tos
- IFS Cloud Power BI Integration Using OData ProjectionsHow to connect IFS Cloud to Power BI using OData projections, which authentication to use, and how to avoid slow reports and overloading the ERP database.
- Embedding Power BI reports inside D365 Finance and Operations workspacesHow to set up embedded Power BI in Dynamics 365 Finance and Operations: register the workspace, publish reports, add tiles to workspaces, and use the entity store.
Runs with your ERP
- Versino Power BI Add-on and SAP Business One: ready datasets and dashboardsHow the Versino Power BI add-on exposes SAP Business One data as ready datasets, what it covers, what breaks, and where a private on-prem AI layer helps.
- Eureka BI (Power BI) with Infor SyteLineWhat is known about the Eureka BI Infor Marketplace listing for SyteLine and VISUAL, built on Microsoft Power BI, plus setup, pitfalls and a private AI layer.
- Birst Analytics and Infor SyteLineHow Birst, Infor's cloud BI platform, fits with SyteLine: what data it reads, setup steps, common pitfalls, alternatives, and where private AI helps.
Guides
- Power BI Integration with SyteLineConnect Power BI to Infor SyteLine for manufacturing analytics. Configure DirectQuery, build data models from SL tables, and publish interactive dashboards.
- Infor LN Reporting Limitations and SolutionsSolve Infor LN reporting limitations. Compare built-in reports, BIS, Birst, Power BI, and custom SQL solutions for manufacturing analytics.
- BAAN Reporting Modernization and BI Platform MigrationModernize BAAN reporting with BI platform migration, Crystal Reports replacement, real-time dashboards, and self-service analytics for legacy BAAN environments.
AI on your ERP
- AI for Priority ERP: grounded answers without leaving your data planeHow to add AI to Priority ERP without sending tabgen data off-site: connectors, RAG over the Priority API, deployment options, and honest trade-offs.
- AI for Power BI on ERP Data: Answers Beyond the Dashboard You Already BuiltAdd grounded natural-language answers on top of Power BI semantic models and live ERP tables, with row-level security respected and models served on-prem.
Integrations
- How to connect Power BI to Infor SyteLineHow to connect Power BI to Infor SyteLine: direct SQL Server, IDO or ION API, data warehouse options, on-prem gateway, key dashboards, and natural-language Q&A.
- How to connect Power BI to Infor LNHow to connect Power BI to Infor LN: direct database, ION and Data Lake options, on-prem data gateway, key manufacturing dashboards and adding natural-language Q&A.
Software
- Priority SoftwarePriority Software ERP explained: modules, low-code customization, OData API integration, deployment options, limitations and alternatives for manufacturers.
- Microsoft Power BIVendor-neutral guide to Microsoft Power BI for manufacturers: modules, ERP and MES integrations, strengths, limitations, alternatives and AI use cases.