Forum Discussion

mariussve1's avatar
mariussve1
Solution Sage
2 years ago
Solved

Issues with the API: Items - Get Report Definition

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"
 
 
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?
 
Br
Marius 🙂
Need Help
  • mariussve1's avatar
    mariussve1
    2 years ago

    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

8 Replies

    • mariussve1's avatar
      mariussve1
      Solution Sage
      2 years ago

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

  • tharunkumarRTK's avatar
    tharunkumarRTK
    Super User
    2 years ago

    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

     

    • mariussve1's avatar
      mariussve1
      Solution Sage
      2 years ago

      Hi,

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

       

      br

      Marius

  • mariussve1's avatar
    mariussve1
    Solution Sage
    2 years ago

    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

    • Longg's avatar
      Longg
      New Member
      2 years ago

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

  • mariussve1's avatar
    mariussve1
    Solution Sage
    1 year ago

    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 😞