Hello all.

I am new to ServiceDesk Plus but have used PowerBI a lot in the past. I was able to get connected to my PGSQL database and pull some tables. For my first dashboard I am planning on simply showing the current tickets for each group/queue, and some other related data. I found a lot of what I need in the 'workorder' table, but am having a hard time finding out how to link what group a request in 'workorder' is related to. Any help or other advice on the database structure, PowerBI with SDP, etc. is appreciated.

Thanks!