Anyone know about using API and Microsoft PowerBI? I can connect but can’t find any monitoring data. Thanks
Hi–to my knowledge you’re the first QuantAQ user to attempt this. Congratulations 
Could you share more about what’s going wrong? / when you say you can connect, are you confident there’s no error?
A good endpoint to test might be the one that returns only your own account information (QuantAQ Cloud API | QuantAQ Docs). If you can get that data in, it’s a good sign that the authentication of your request is working, and we can move on to other issues that might be arising.
Thanks, and let me know if you have other questions.
I am using this connection in the web connector:
(I hid the API key)
And am able to pull in the info like I do with other data sources:
The problem is I can’t actually find the data.
I think I am using the wrong URL, but I’ve tried every one I could and do not see the monitoring data.
Hi–looks to me like you’re using the url from the web application in that dialog. To use the API, the url will be different, both in the domain (api.quant-aq.com) and the structure: QuantAQ Cloud API | QuantAQ Docs. For what it looks like you’re trying to do, I think something like https://api.quant-aq.com/v1/devices?org_id=1218&network_id=57 would probably work.
Note that by default the API paginates, with 50 entries per page, which may exceed the number of devices that you get. In that case, you’ll either want to handle iterating through the pages (not sure how that works in Power BI), or attach an additional parameter like “&per_page=100”, to get 100 in a page. The maximum value of per_page is 1000–if you have more objects than that, you’ll need to use pagination.
Let me know if this solves your issue, or if you have any questions.
I used the link you gave me and now I am getting this error:
It looks like I am connecting but am going to the wrong url now and Power BI won’t accept the redirect.
I did some research and I need to get a list of devices and then do a loop query based on the device list. I tried getting the list of devices but get the same redirect error.