How to get Report Page list based on Report ID using power bi client in C#?

Question

Need to get page list of a Report based on ReportId from powerbi in my web api project. Couldn't find any option in power bi client object for fetching page info in C# web api. Tried using HttpClient then but still getting forbidden error with below code-

        var accessToken = await GetAccessToken(authMode);
        client.BaseAddress = new Uri("https://api.powerbi.com/v1.0/myorg/");
        client.DefaultRequestHeaders.Accept.Clear();
        client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
        client.DefaultRequestHeaders.Add("Authorization", "Bearer " + accessToken);

        HttpResponseMessage response = await client.GetAsync("reports/" + reportId);
        if (response.IsSuccessStatusCode)
        {
            var pageList = await response.Content.ReadAsAsync<List<PageInfo>>();
            return pageList;
        }
        return Enumerable.Empty<PageInfo>();

Parth Mangukiya · Accepted Answer · 2021-07-30 13:41:52Z

1

There is currently no way you can get all the pages of a report based on reportId using C# Web API.

Please check:
https://community.powerbi.com/t5/Developer/Get-List-Of-Report-Pages-via-C-Rest-API/m-p/376293

However, you can use powerbi-client (JS SDK) to get all the pages of a report.

Please refer below code:

// reportContainer: HTML div element in which report is being embedded
// config: Report embed configuration object
const report = powerbi.embed(reportContainer, config);
const pages = await report.getPages();

// pages is an array which contains all the pages available for the given report.
console.log(pages);

Please refer here:

answered Jul 30, 2021 at 13:41

Parth Mangukiya

4524 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Julia Hayward · Accepted Answer · 2024-01-16 13:46:08Z

0

It looks like this is now possible:

var report = await pbiClient.Reports.GetReportInGroupAsync(WorkspaceId, ReportId);
var pages = await pbiClient.Reports.GetPagesInGroupAsync(WorkspaceId, ReportId);

(using Microsoft.PowerBI.Api v4.18.0)

answered Jan 16, 2024 at 13:46

Julia Hayward

2,1851 gold badge15 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to get Report Page list based on Report ID using power bi client in C#?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related