Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Export to file - Power BI Report with Filters / Parameters

HI All, I am looking at the new (currently in preview) API for exporting Power BI reports as images/pdf files. https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofileingroup  T...
General Comment
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I went looking at options for this... The only oneI can find (the one I was previously experimenting with) was via the JavaScript embedding API. https://github.com/Microsoft/PowerBI-JavaScript/wiki/Bookmarks

The section at the end shows how to capture a bookmark programatically. The resulting object then holds the bookmark state.

// Capture the current view
let capturedBookmark = report.bookmarksManager.capture();

// Applied previously captured state
report.bookmarksManager.applyState(capturedBookmark.state);

 

I tried to work out how this state object was structured, in the hope I could dynamically create it in C#... but I didn't get very far.

As I mentioned before... If you only have a small number of filters and bookmark states that you need to capture, then you could use this method to fetch those states and reuse them as many times as you like. But as soon as you want to do anything really dynamic... you hit a bit of a blocker.

I am keeping my fingers crossed for quick updates to the API to add the parameters. 😀

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    latearrival 

    I am using the REST APIs for ExportToFile in my Power Automate flow.

    I can export the PDF with no issues in a normal use case, but next I want to try out exporting a PDF with a particular bookmark.

    Use case is - I have 5 user groups and I will create 5 bookmarks (one for each).

    Will send the PDF in an email to each of them as per their individual bookmarks.

     

    However, when I try to put the bookmark name in my flow, it doesn't work.

    Here is how my flow looks -

     

    The error I get is -

    {
      "error": {
        "code": "BadRequest",
        "message": "Bad Request",
        "details": [
          {
            "message": "Error converting value \"Group1_bookmark\" to type 'Microsoft.PowerBI.ServiceContracts.Api.V1.PageBookmark'. Path 'powerBIReportConfiguration.defaultBookmark', line 1, position 74.",
            "target": "request.powerBIReportConfiguration.defaultBookmark"
          }
        ]
      }
    }
     
    Appreciate if you can provide any inputs in case you have any ideas around this use case?
     
    Regards