Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jasandov
Regular Visitor

PowerBI Rest API unable to export PDF with Correct Bookmark

I'm unable to export a report with correct bookmarks when using the Rest API. I am able to get the report, but the correct filters are not set. (This is for an embedded app, and I am using the powerbi javascript library to capture the bookmark state ) I have been able to test my parameters using the "Power Automate" service, and I am able to obtain the report with the correct filters/bookmarks from that service. Here is a code snippet of what I believe to be the culprit:

 

        private async Task<string> PostExportRequest(
            Guid reportId,
            Guid workspaceId,
            FileFormat format,
            IList<string> pageNames,
            PageBookmark bookmark)
        {
            string pageName = pageNames[0];
            try
            {
                var pbiReport = await pbiClient.Reports.GetReportInGroupAsync(workspaceId, reportId);
                var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
                {
                    Settings = new ExportReportSettings
                    {
                        Locale = "en-us",
                    },
                    DefaultBookmark = new PageBookmark(bookmark.State),
                    Pages = new List<ExportReportPage>() { new ExportReportPage(pageName)},
                    Identities = new List<EffectiveIdentity> { new EffectiveIdentity(username: SPN_ObjectId, datasets: new List<string> { pbiReport.DatasetId }) },
                };

                    var exportRequest = new ExportReportRequest
                    {
                        Format = format,
                        PowerBIReportConfiguration = powerBIReportExportConfiguration
                    };
    
                    var export = await pbiClient.Reports.ExportToFileInGroupAsync(workspaceId, reportId, exportRequest);
                    return export.Id;
            }
            catch (HttpOperationException ex)
            {
                _telemetryClient.TrackException(ex);
                throw ex;
                
            }

 

 

 

 

 

1 REPLY 1
v-yetao1-msft
Community Support
Community Support

Hi @jasandov 

I found an API introduction about bookmark, maybe you can refer to it .

https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/report-bookmarks

 

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors