Export Report with ExportToFileInGroupAsync and Bookmarks using State from Frontend

GianmarcoItaca — Fri, 21 Oct 2022 07:21:06 GMT

I am trying to apply a bookmark while exporting the report. I have an angular front end and I am using the power-bi-client module to capture the bookmark from the report:

var bookmark= await embed.bookmarksManager.capture();
var state= bookmark.state

Then i pass the state to .NET backend to create a bookmark with the state:

PageBookmark bookmark = new PageBookmark(state:state);

And finally to call ExportToFileInGroupAsync with the info:

public static async Task<string> PostExportRequest(
string id_execution,
PageBookmark bookmark,
string dataset_id,
Guid reportId,
Guid groupId,
FileFormat format,
PowerBIClient Client,
IList<string> pageNames = null, /* Get the page names from the GetPages REST API */
string urlFilter = null)
{
    var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
    {
    Settings = new ExportReportSettings
        {
        Locale = "en-us",
        },
    DefaultBookmark = bookmark, /////////////HERE
    Pages = pageNames?.Select(pn => new ExportReportPage(pn)).ToList(),
    Identities = new List<EffectiveIdentity>() {new EffectiveIdentity()
        {
        Roles = new List<string>() { "role1" },
        Username = id_execution,
        Datasets = new List<string>() { dataset_id }
        }
    }

    };

    var exportRequest = new ExportReportRequest
    {
    Format = format,
    PowerBIReportConfiguration = powerBIReportExportConfiguration,
    };
    try
    {
    var export = await Client.Reports.ExportToFileInGroupAsync(groupId, reportId, exportRequest);
    return export.Id;
    }
    catch (Exception e)
    {
    return e.Message;
    }

}

The call works without the bookmark, but it returns a generic BadRequest with it.

How am I supposed to pass the bookmark?

Re: Export Report with ExportToFileInGroupAsync and Bookmarks using State from Frontend

lbendlin — Sun, 23 Oct 2022 01:20:28 GMT

you can practice your call (and validate the format) here

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Read about the limitations here

Export Power BI embedded analytics reports API - Power BI | Microsoft Learn

(note the limitation on personal bookmarks)

NOTE: The bookmark name may not be what you think it is. Retrieve the bookmarknames to see what the format is. Should be bookmark<guid>

topic Re: Export Report with ExportToFileInGroupAsync and Bookmarks using State from Frontend in Developer

Export Report with ExportToFileInGroupAsync and Bookmarks using State from Frontend

Re: Export Report with ExportToFileInGroupAsync and Bookmarks using State from Frontend