ferrybouwman/power-bi-read-only-rest-api

Solution based on either Powershell or Power Automate (Flow) to consume the recently released Power BI Asynchronous Unified Scanning API

power-bi-read-only-rest-api's Issues

json parsing issue

on the call getInfo endpoint I am hitting an error that it cannot parse the json

"message": "Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Guid' because the type requires a JSON primitive value (e.g. string, number, boolean, null) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON primitive value (e.g. string, number, boolean, null) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.\r\nPath 'workspaces[0].id', line 1, position 22.",
"target": "requiredWorkspaces.workspaces[0].id"

the json array is coming out like this:
"workspaces": [{"id":"6c0d5435-11d1-4cb3-83df-0a7d69f781fb",{"id":"699d67ca-416d-46f7-bf2f-c521e4fa28ff",{"id":"047e62c3-8d64-4384-80bc-4e1e5278864e"

I'm not sure where to force something like the jsonobjectattribute and I haven't changed any of the power automate steps. I'm not very familiar with json at all any help would be appreciated.

Unknown Error received when trying to import the flow

Hi Ferry,

Receiving an unknown error when trying to import the flow. Tried this on multiple environments and the behavior is the same.

Getting Error The variable 'responseArrayASString' has size of more than '105910233' bytes.

I have followed all the steps mentioned in the video and when I ran the flow it is erroring out at step "Step 3: Retrieve Data"->"Append to String variable"
The variable 'responseArrayASString' has size of more than '105910233' bytes. This exceeded the maximum size '104857600' allowed.
We have more than 6000 Workspaces.