Report Server REST API - Get sheets

[Tommoo92]

Hello!

Is it possible to get all sheets that exists in a report from the REST API?

BR

Tommie

[Icey]

Hi @Tommoo92 ,

I'm afraid it is not supported to get all sheets that exists in a report from the REST API currently.

But it is supported to get all Data Sources like so:

let
    Source = OData.Feed("http://localhost/reports/api/v2.0", null, [Implementation="2.0"]),
    PowerBIReports_table = Source{[Name="PowerBIReports",Signature="table"]}[Data],
    #"Removed Other Columns" = Table.SelectColumns(PowerBIReports_table,{"Id", "Name", "Path", "Type", "ModifiedBy", "ModifiedDate", "CreatedBy", "CreatedDate", "DataSources"}),
    #"Expanded DataSources" = Table.ExpandTableColumn(#"Removed Other Columns", "DataSources", {"ConnectionString", "DataModelDataSource"}, {"ConnectionString", "DataModelDataSource"}),
    #"Expanded DataModelDataSource" = Table.ExpandRecordColumn(#"Expanded DataSources", "DataModelDataSource", {"Type", "Kind"}, {"Type.1", "Kind"})
in
    #"Expanded DataModelDataSource"

 

Reference: Getting a list of Power BI reports and Data Sources from the Power BI API - SQL Ryan

Best Regards,

Icey

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

[Tommoo92]

Note that this is the Report Server API and not PBI Service API