topic Re: Missing DatasetId for Paginated Reports (Get-PowerBIReport) in Developer

Missing DatasetId for Paginated Reports (Get-PowerBIReport)

karo — Fri, 13 Jan 2023 13:06:26 GMT

Hi,

Do you know why Get-PowerBIReport does not providing DatasetId for Paginated Reports?

Regards,

Karo

Re: Missing DatasetId for Paginated Reports (Get-PowerBIReport)

lbendlin — Mon, 16 Jan 2023 00:27:57 GMT

Because a report is different from a dataset? What are you trying to achieve?

Re: Missing DatasetId for Paginated Reports (Get-PowerBIReport)

karo — Mon, 16 Jan 2023 07:00:43 GMT

I am trying to get the full list of all Power BI Reports (including Paginated) with corresponding DatasetId, but for all Paginated Reports DatasetId is blank.

Re: Missing DatasetId for Paginated Reports (Get-PowerBIReport)

AmosHersch — Mon, 16 Jan 2023 07:35:16 GMT

Hi @karo ,

A paginated report doesn't neccessarily have a dataset. It has data sources, and one or more of them can be of type "Power BI Dataset".

You can call an API to get the pagintated report's data sources, and filter the response according to the type.

Reports - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Re: Missing DatasetId for Paginated Reports (Get-PowerBIReport)

karo — Mon, 16 Jan 2023 07:44:39 GMT

@AmosHersch thanks for a hint. I will try.

Even if not all Paginated reports have Dataset, I would expect to see DatasetId for those where it exists ... and it is not a case