Power bi report server metadata

omnia_saleh — Wed, 14 Feb 2024 11:24:03 GMT

why content column in table catalog contain value for a report and null value for the dashboard why report only i want explain?

are the lineage of the dashboard store in ReportServer database?

Are column content in [dbo].[CatalogItemExtendedContent] contain information about dashboard?

Re: Power bi report server metadata

Anonymous — Thu, 15 Feb 2024 03:01:46 GMT

Hi omnia_saleh ,

Content Column in Catalog Table:

The table within the ReportServer database contains a row for every object managed by the SQL Server Reporting Services (SSRS) site. These objects include reports, linked reports, shared data sources, report models, folders, and images.dbo.Catalog
The column in this table is a binary value and holds the actual XML definition of the object where appropriate. For instance, it stores the report definition in XML format.content
If you want to view the actual XML content rather than the binary value, you can use the following query:

SELECT [Path], CASE [Type] WHEN 2 THEN 'Report' WHEN 5 THEN 'Data Source' END AS TypeName, CAST(CAST(content AS varbinary(max)) AS xml) AS ReportDefinition, [Description] FROM ReportServer.dbo.Catalog;

CatalogItemExtendedContent Table:

The table contains additional content related to catalog items. It includes multiple rows for PBIX reports, each with a different .dbo.CatalogItemExtendedContentContentType
When dealing with PBIX reports, the column in the table is NULL. However, you can find relevant information in the table.contentdbo.Catalogdbo.CatalogItemExtendedContent

SELECT CT.[Path], CT.[Type], cc.ContentType, CONVERT(varbinary(max), cc.[Content]) AS BinaryContent FROM dbo.Catalog CT INNER JOIN dbo.CatalogItemExtendedContent cc ON CT.ItemID = cc.ItemID WHERE cc.ContentType = 'PowerBIReportDefinition';

Below is the post will help you:

[GetCatalogExtendedContentData] procedure killing ... - Microsoft Fabric Community

Best Regards,

Xianda Tang

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

topic Re: Power bi report server metadata in Report Server

Power bi report server metadata

Re: Power bi report server metadata