Conditions

[epiphanyplx]

Hello,

Thanks for this, was using Comer's post (referenced by everyone when searching for Connectwise + PowerBI but only accessible through Wayback machine) but couldn't figure out how to use conditions.

I believe I am able to use them with the provided query for Manage, like so:
= CWManageApiRequest("finance/invoices", [date="2024-09-01T00:00:00Z"], false)

However, A) it has been loading for some time, wondering if despite the condition it's loading all 15k+ rows as my basic query using Comer's post did, B) doesn't seem to be a status on loaded rows?, and C) I can't figure out how to specify a condition that would require a column to be expanded.
New to PowerBI so apologies if this is the wrong terminology, but when using CWM Powershell module I can do something like company/name="Company LLC" but can't figure out how to do that here.

Is it standard with PowerBI to just not use conditions and then apply filters afterwards?

Even when trying to filter like this:
= CWManageApiRequest("finance/invoices", [id="77"], false)
It seems to just spin forever.

Thanks for any help, not a ton of information on Google about CWM+PowerBI, everything essentially points to Comer's deleted posts or this repository.