# Using Power Bi to query tables
**URL:** https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673
**Category:** API Queries (How To)
**Created:** [May 25, 2023, 11:41am UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673 "2023-05-25T11:41:19Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@CAVH](https://developer-forum.veeqo.com/u/CAVH)
#### Post date: [May 25, 2023, 11:41am UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/1 "2023-05-25T11:41:19Z")
I’m not a developer! I think the reports in Veeqo are so limited.
Is there a way to query the tables, maybe via SQL Studio or Microsoft Power Bi?
Thanks
---
### Author:  [@Reuben](https://developer-forum.veeqo.com/u/Reuben)
#### Post date: [June 16, 2023, 3:44pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/2 "2023-06-16T15:44:05Z")
You should check out [Meltano](https://meltano.com/) and try using the open-source connector we built for Veeqo with it: [`tap-veeqo`](https://hub.meltano.com/extractors/tap-veeqo). You can definitely run a sync from `tap-veeqo` to some database (most major ones are supported by Meltano) and have Power BI query the resulting table. 🙂
---
### Author:  [@Reuben](https://developer-forum.veeqo.com/u/Reuben)
#### Post date: [June 16, 2023, 3:44pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/3 "2023-06-16T15:44:38Z")
Happy to chat in [our Slack](https://join.slack.com/t/matatika/shared_invite/zt-1shuod7dx-nrmh6aP8ZuBcS9XY~7BuGw) if you want! 🕶
---
### Author:  [@caltenk](https://developer-forum.veeqo.com/u/caltenk)
#### Post date: [October 9, 2023, 4:55pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/4 "2023-10-09T16:55:50Z")
Hey @CAVH!
My name is Cameron, I’m one of the support engineers here at Veeqo.
SQL Studio and Power BI are tools for querying data that you’ve got access to locally (with some exceptions).
You’ll first need to export the data from Veeqo using our Web API which you can find documentation for [here](https://developers.veeqo.com/docs), by building some kind of connector/bridge.
There are some pre-existing connectors that have been built by members of the community if you’re not a developer or don’t have access to one but I wouldn’t be able to advise on specifics.
Once you’ve done that and stored the data in some kind of data store that can be accessed by one of the tools you mentioned you can query it freely.
Let me know if you have further queries
---
### Author:  [@CAVH](https://developer-forum.veeqo.com/u/CAVH)
#### Post date: [October 10, 2023, 7:17am UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/5 "2023-10-10T07:17:17Z")
Thanks @caltenk. I’ll follow up.
---
### Author:  [@CAVH](https://developer-forum.veeqo.com/u/CAVH)
#### Post date: [October 19, 2023, 2:11pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/6 "2023-10-19T14:11:02Z")
@caltenk I’ve successfully connected to Veeqo with Microsoft Power Bi using the Orders API, which I’m very happy about. It’s only taken me months of trying!
I’m looking for a field via the API that I simply cannot find: **quantity\_shipped** I know it exists as it’s on a report that I run.
Any guidance on where I can find it?
Thanks
---
### Author:  [@caltenk](https://developer-forum.veeqo.com/u/caltenk)
#### Post date: [October 19, 2023, 3:02pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/7 "2023-10-19T15:02:01Z")
Hey @CAVH, glad to hear that
Can I ask what you’re looking to see with that field, is it the quantity of a line item on an order that have been shipped?
If so, I’m not sure if it’s something that’s exposed via the API but I can check
---
### Author:  [@CAVH](https://developer-forum.veeqo.com/u/CAVH)
#### Post date: [October 19, 2023, 3:19pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/8 "2023-10-19T15:19:58Z")
@caltenk Yes, that’s exactly it. I might expand an order where there are 2 line items - products A & B. Let’s say the customer orders 2 x A and 1 x B and we’re able to ship it in part: 1 x A and 1 x B, with 1 x A still o/s.
Quantity ordered less qty shipped = qty not yet shipped at a given point when the report is run.
Thanks
---
### Author:  [@caltenk](https://developer-forum.veeqo.com/u/caltenk)
#### Post date: [November 13, 2023, 4:53pm UTC](https://developer-forum.veeqo.com/t/using-power-bi-to-query-tables/673/9 "2023-11-13T16:53:52Z")
Hey @CAVH, sorry for the delay in my response
From my knowledge and understanding of the desired outcome, returning this information is possible but unfortunately not trivial since we don’t expose a `shipped_quantity` field against `line_items` on an order.
However it is possible to check whether an allocation against an order is shipped or not by using the `shipped` attribute and checking if it is `null` or not.
Using this, you could query the allocations for an order, check if they’re shipped or not, and then look at the line\_items in that allocation.
Hopefully this makes sense