Hi @omnia_saleh ,
If metadata is not enabled, the ReportServer will not be able to store information about reports, datasets, and data sources. This may result in the corresponding metadata records not being found in the ReportServer database in SSMS.
Report Server Configuration: You need to ensure that the Metadata option is enabled in the Power BI Report Server configuration. This allows the report server to store the relevant information in the ReportServer database for subsequent querying and management.
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.
