Hello, Lansweeper Community.
I’m currently in the process of creating a series of Power BI dashboards for our various departments to provide them a general overview of the assets within their respective domains. The goal is to make these dashboards as clean and specific as possible, focusing only on relevant assets, and excluding decommissioned, inactive, or irrelevant computers.
I am using the API documentation seen in the Knowledge Base here and have successfully been able to create API calls to our LS Cloud instance on several occasions now. However, there are an odd few thousands of assets that get pulled in with this call, all of varying degrees of states and fields I want to exclude. This led me to create the aforementioned Custom Reports, creating one for each department with the relative filters and state exclusions I want--these look and work great for exactly what I need pulled into Power BI, but I can't.
I assumed that when exposing a report to the API, and making a direct call to the API in PowerBI, it would create a separate table for these custom reports, much like how the guide creates these data containers:

But that does not seem to be the case. Even after marking the report as "Exposed to API," there doesn’t seem to be a new entity, container, or obvious way to directly query just that custom report through the API, at least not in PowerBI.
I've found that it may have been required to gather the 'Custom Report ID', so I was able to query using Postman to get this 'authorizedReports' ID for my custom reports; but not sure how this (or the 'Export URL' I've also queried for) are of any help for this use case. (See here for more details on why I went down this road)
It's entirely possible I am vastly misunderstanding what exactly the 'Expose to API' function is for, and maybe it doesn't have any capacity to work with PowerBI. I am a relative newbie to the API Integration world, so I appreciate any and all ideas or assistance in getting this going. For context, too, I will have an odd 50+ reports that will all have various degrees of filters and exclusions. These reports would be vastly improved by allowing them to connect via/ some form of automatic data request and not manual uploads into Power BI.
Please let me know if there is any further information I can provide!