topic Issues with the API: Items - Get Report Definition in Developer

Issues with the API: Items - Get Report Definition

mariussve1 — Sat, 20 Apr 2024 23:43:24 GMT

Hi,

I have been using a lot of the API's from Power BI, and with great luck.

Now I'm creating some cool stuff by using Log Analytics, and one of the things I get from Log Analytics is the VisualID. To connect VisualID to the correct Report page in a report I need to find this in the report.json file. This is something I can get with the Get Report Definition API.

But, when I try to use this API it returns this error message:

"errorCode": "BadRequest",

"message": "Unable to process the operation due to an error in the request"

In the documentaion it does not say anything about the body:
https://learn.microsoft.com/en-us/rest/api/fabric/report/items/get-report-definition?tabs=HTTP

As you can see the doc says its a POST, but no body as I can see. I have tried to use GET as well, but no luck.

When I hit the TRY IT button it works, so that is really strange.

Someone else been in the same situation and can help out?

Marius 🙂

Re: Issues with the API: Items - Get Report Definition

AmosHersch — Sun, 21 Apr 2024 05:39:39 GMT

Hi @mariussve1 ,

Did you try calling the API for the same report from the "Try It" page of the documentation Items - Get Report Definition - REST API (Report) | Microsoft Learn ?

If it returns an error, can you please paste here and response headers and body?

Re: Issues with the API: Items - Get Report Definition

tharunkumarRTK — Sun, 21 Apr 2024 05:54:23 GMT

@mariussve1

I ran a POST call from Power BI and it is working, Follow the below snippet and you should be able to run

let Source = Json.Document(Web.Contents(" https://api.fabric.microsoft.com/v1/workspaces/<workspaceId>/reports/<reportId>/getDefinition",[Headers=[Authorization="Bearer <Bearer Token>",#"Content-Type" = "application/json" ], Content=Json.FromValue([])] )) in Source

dont forget to include your report id, workspsce id and bearer token.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

Re: Issues with the API: Items - Get Report Definition

mariussve1 — Sun, 21 Apr 2024 06:42:12 GMT

Hi, when I use the "try it" button it works, so kt does not give any errors then. Only when I use postman

Re: Issues with the API: Items - Get Report Definition

mariussve1 — Sun, 21 Apr 2024 06:43:19 GMT

Hi,

I will try from Power Query. Are you able to run the request from Postman?

Marius

Re: Issues with the API: Items - Get Report Definition

mariussve1 — Sun, 21 Apr 2024 08:50:40 GMT

I tried to copy the token from "Try It" page of the documentation, and then it works.

I reviewd access to the SPN and found out I needed to grant some more access. Now everything works 🙂

Cheers
Marius

Re: Issues with the API: Items - Get Report Definition

Longg — Mon, 29 Jul 2024 10:28:22 GMT

Hello @mariussve1, could you tell me what permisssion you grant to your SPN. Thank you.

Re: Issues with the API: Items - Get Report Definition

mariussve1 — Fri, 23 May 2025 15:02:11 GMT

Hi,

Does anyone knows if this have stopped working? Im not able to get any result from the api.

It only returns:
Resultat: {'status': 'Succeeded', 'createdTimeUtc': '2025-05-23T14:58:32.8582529', 'lastUpdatedTimeUtc': '2025-05-23T14:58:33.3270162', 'percentComplete': 100, 'error': None}

But the payload and base64 code is missing 😞

Re: Issues with the API: Items - Get Report Definition

mariussve1 — Fri, 23 May 2025 15:03:58 GMT

When I try this "Try it" button here:
https://learn.microsoft.com/en-us/rest/api/fabric/report/items/get-report-definition?tabs=HTTP&tryIt=true&source=docs#code-try-0

It only returns: