Report Server REST API - Get sheets

Tommoo92 — Thu, 29 Apr 2021 13:54:39 GMT

Hello!

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

Tommie

Re: Report Server REST API - Get sheets

Tommoo92 — Thu, 29 Apr 2021 14:02:54 GMT

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

Re: Report Server REST API - Get sheets

Icey — Mon, 03 May 2021 07:16:42 GMT

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.

topic Re: Report Server REST API - Get sheets in Report Server

Report Server REST API - Get sheets

Re: Report Server REST API - Get sheets

Re: Report Server REST API - Get sheets