Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Hi @omnia_saleh ,
Content Column in Catalog Table:
dbo.Catalog
content
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:
dbo.CatalogItemExtendedContent
ContentType
content
dbo.Catalog
dbo.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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.