AFAS and Power BI are a powerful combination. Do you want to effortlessly visualise, report and manage data from one central location? Then linking to Power BI is the smart choice — especially now that AFAS is available from Qlik support will end in December 2025..
Why combine AFAS and Power BI?
- Immediate insight into your AFAS data
- Automated dashboards
- Always up-to-date reports
- Full control over authorisation and publication
Power BI enables you to get more out of your AFAS environment, whether you work in HRM, Finance, or Functional Management.
Guide: Connecting AFAS to Power BI in 5 steps
1. Check your Power BI licence
Would you like to share dashboards? Then you need a Power BI Pro required (e.g. in Microsoft 365 E5). Check this via your Microsoft account.
2. Create a GetConnector
In AFAS, go to:
General → Exports → Management → GetConnector
- Select the desired data collection
- Give your GetConnector a recognisable name
- Check settings carefully?
3. Set up an App Connector
General → Management → App Connector
- Link to a user group
- Select the GetConnector
- Unblock and generate an XML user token
- Encrypt this via base64encode.org
💡 Tip: Make a note of your token securely — you will need it in Power BI.
4. Retrieving data in Power BI
Power BI Desktop → Get Data → Web
- Use the requested URL: https://[environment no.].rest.afas.online/profitrestservices/connectors/[nameGetConnector]?skip=-1&take=-1
- Replace
[environment no.]and[nameGetConnector] - Filling in headers:
- Header name:
Authorisation - Value:
AfasToken [your base64 code]
- Header name:
5. Build and publish your dashboard
- Create clear dashboards
- Publish to Power BI Online
- Set up scheduled updates (daily or weekly)
🔁 Data is now refreshed automatically. No more manual exports!
What should you pay attention to?
- Authorisation: you decide who sees what
- Publication policyBe clear about access and confidentiality.
- Technology vs. humans: ensure your team understands how Power BI works, or engage a AFAS consultant in
Need assistance? Process Builders is here to help!
Our AFAS Mentors guide you step by step. Whether you want to have the link built or train your own team — we think along with you.
📞 Call 033 208 4718 or email hallo@procesbouwers.nl
Frequently asked questions
What is a GetConnector?
A specific data export from AFAS Profit that can be automatically loaded into Power BI.
What will happen to Qlik after December 2025?
AFAS is permanently discontinuing Qlik. Power BI is the future-proof BI solution.
Can I combine multiple data sources in Power BI?
Yes, you can combine AFAS data with other sources such as Excel, Salesforce or Google Analytics.
Is technical knowledge required?
A little bit — but we'll help you. Check Outsource AFAS or schedule an onboarding session with our team.
Conclusion
Linking AFAS to Power BI is a powerful step towards smarter reporting and better decision-making. Follow our step-by-step plan, avoid mistakes and enjoy real-time insights with minimal effort. Time to say goodbye to Qlik — and hello to Power BI!
