Forum Discussion
power bi report server metadata
1- Are tables for each report in power bi report server read from and store in ReportServer Database In SSMS ?
2- If this table Store How can i access this tables?
6 Replies
Hi omnia_saleh ,
Yes, the metadata for each report in Power BI Report Server is stored in the ReportServer database in SSMS. The ReportServer database contains tables that store information about reports, data sources, schedules, subscriptions, and other objects.
For more details,You may refer to Solved: How Report server store and run the Power BI repor... - Microsoft Fabric Community
As for the second question,hope these threads help.
Extract Power BI metadata to manage datasource changes – Find it EZ
Metadata scanning - Power BI | Microsoft Learn
Best regards.
Community Support Team_Caitlyni have information that each report read from any database read from teradata as example but i dont have read from any tables in teradata
ReportServer database contains tables that store information about reports, data sources, schedules, subscriptions, and other objects. Each report comes from tables within specific databases. Are these tables stored in a ReportServer database?
Hi omnia_saleh ,
I'm not sure I understand your question. Could you please rephrase or provide more context? Are you saying that you have information that reports are being generated from a Teradata database, but you don't have access to the tables in that database?
Best Regards,
Community Support Team _ Caitlynin ReportServer database store each report and come from any database like this report1 come from teradata this informatin store in a table [dbo].[DataModelDataSource]
Are tables for each report in power bi report server read from and store in ReportServer Database In SSMS
Depeneds on type of report.
For Power BI reports, there is information only on connection level (for each connection used in report is there type of source, server and so on). But not on table or query level (this information is inside blob of pbix file in enhanced metadata format, and is not directly accessible in ReportServer database via SQL query)
