1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Connecting to PDQ Inventory database with Power BI?

Avatar
Jonas Andresen

Is there a way to connect to the PDQ Inventory database with Power BI?

I'd love to make dashboards based on the information PDQ has. It would make pretty reports for non-it managers over their users computers.

0

Comments

4 comments
Date Votes
  • Avatar
    Robert Basil

    You need to install an SQLite ODBC driver (look here: http://www.ch-werner.de/sqliteodbc) on your PDQ server. Then "Get Data" - "ODBC" and enter "database=Database-Location\Database.db" as connection string. This works at least for the PowerBI Desktop.

    All PDQ data is stored in the database's.

    C:\ProgramData\Admin Arsenal\PDQ Deploy\Database.db

    C:\ProgramData\Admin Arsenal\PDQ Inventory\Database.db

    0
  • Avatar
    David Iannello

    Hi,

    Thanks for the instructions! I have successfully connected to the database and started to explore the possibility to create PowerBI reports.

    A question that popped in my head, is there some sort of repository out there where I can find reports already made by the community or anyone that have already explored this possibility and that is willing to share some report?

    0
  • Avatar
    Bscruggs

    Hi all, 

    I'm following these directions but running into an "out of memory" error. Has anyone seen this before or know of a solution?

    If relevant, I'm trying to connect a Power Bi instance on my local machine to the PDQ database on a virtual machine. I'm not sure if that makes a difference. 

    thanks, 

    Bryon S.

    0
  • Avatar
    Beau Bebout

    Hi,

    Does the PDQ database have to be on the local machine I'm utilizing PowerBI Desktop on, or can I reference it from a network location? Someone else manages the pushes with PDQ and I'd like to track the progress in BI.

    0