HorecaPOS· OptimumPOS

Connect Microsoft Power BI to HorecaPOS

With the integration between HorecaPOS and Microsoft Power BI, you get a ready-made report of your turnover, products and staff. Download the Power BI template (.pbit) in the POS, with tables, a calendar, relationships and measures such as turnover per guest and turnover per hour worked. Via the portal, the Power BI service refreshes the data on a schedule, without a gateway. You can also have CSV files put in a OneDrive or SharePoint folder every day.

What the integration with Microsoft Power BI does

  • Report pages: Overview, Products and Staff
  • When opened, the template asks for address, key and period
  • Connect yourself: Get data → Web, authentication Anonymous
  • Files also via SFTP or by email

BI and data export

Your sales and turnover from the POS in Microsoft Power BI, for your own reports and dashboards.

This integration works straight away: the administrator switches it on in the POS settings and enters the Microsoft Power BI details there.

Frequently asked questions

Does Microsoft Power BI work with HorecaPOS?

Yes. With the integration between HorecaPOS and Microsoft Power BI, you get a ready-made report of your turnover, products and staff.

How do I switch on the integration with Microsoft Power BI?

In the POS: Settings, under integrations. The administrator enters the Microsoft Power BI details there; after that it works automatically.

Do I need an account with Microsoft Power BI?

Yes, you use your own account or subscription with Microsoft Power BI. The integration itself is built into HorecaPOS.

What is HorecaPOS?

HorecaPOS is POS software for restaurants, cafés, snack bars and takeaways in the Netherlands and Belgium: tables, ordering, checkout, card payments and kitchen display, even without internet. You can use it free for 3 months, with no strings attached.

More integrations: BI and data export

Ready to get started?

Use the app free for 3 months, no strings attached. Download it, create an account and pair your POS.