(warning) The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.

PowerBI Connector Documentation

User Persona: Paxata User

About

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

To Configure

  1. Open PowerBI Desktop
  2. Select Get DataOtherPaxataConnect 
     
    then 
  3. If you receive a warning about "Connecting to a third-party service", click Continue.
  4. Enter the Paxata URL you log in at and click OK.
    1. 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.
    2. Don’t forget to add “https://” at the beginning
  5. Enter your Paxata REST API Token and click Connect.
    1. If you do not have a REST API Toke, this article will show you where to get one (look under item 7 - Tokens).
    2. Save this token, as it cannot be retrieved, only deleted and regenerated, if lost.
  6. 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.

Best Practices

  • 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:
    1. 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.
    2. 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.