User Persona: Paxata User
Paxata connectivity to PowerBI Desktop works differently than the other documented Paxata Connectors. This Connector is built on the PowerBI Desktop Platform and is configured in PowerBI Desktop to reach out to Paxata.
For more information from Microsoft on PowerBI Desktop Data Sources, please see: https://docs.microsoft.com/en-us/power-bi/desktop-data-sources
- Open PowerBI Desktop
- Select Get Data → Other → Paxata → Connect
- If you receive a warning about "Connecting to a third-party service", click Continue.
- Enter the Paxata URL you log in at and click OK.
- This may be "https://yourdomain.paxata.com/domain/paxauth” if you’re on a Kubernetes based deployment, or “https://yourdomain.paxata.com/” if you’re on a non-Kubernetes based deployment.
- Don’t forget to add “https://” at the beginning
- Enter your Paxata REST API Token and click Connect.
- If you do not have a REST API Toke, this article will show you where to get one (look under item 7 - Tokens).
- Save this token, as it cannot be retrieved, only deleted and regenerated, if lost.
- It may take a minute or so for the authentication to process. Upon completion, you'll land on the screen where you can browse the Paxata Data Library for Data Files and AnswerSets to import.
- For ad hoc reporting, using this Connector is the recommended path.
- For automated reporting/updating published dashboards, there are several approaches worth considering as automating a process on a Desktop is not possible. Here’s one approach that we’ve seen be successful in several situations:
- Automate your data preparation in Paxata and export to a storage location that can be directly queried by a published PowerBI Dashboard, such as ADLS Gen2.
- Using a separate automation on the PowerBI side, import the Paxata AnswerSet into PowerBI from the shared location.
If you have further questions, please contact your Paxata Customer Success Representative.