Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to Solution.
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
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 😞
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...
It only returns:
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
Hello @mariussve1, could you tell me what permisssion you grant to your SPN. Thank you.
@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
Hi,
I will try from Power Query. Are you able to run the request from Postman?
br
Marius
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?
Hi, when I use the "try it" button it works, so kt does not give any errors then. Only when I use postman
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |