topic Re: power bi report server metadata in Report Server

power bi report server metadata

omnia_saleh — Tue, 13 Feb 2024 06:58:00 GMT

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?

Re: power bi report server metadata

Anonymous — Tue, 13 Feb 2024 09:44:43 GMT

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_Caitlyn

Re: power bi report server metadata

omnia_saleh — Tue, 13 Feb 2024 11:08:42 GMT

i have information that each report read from any database read from teradata as example but i dont have read from any tables in teradata

Re: power bi report server metadata

Anonymous — Wed, 14 Feb 2024 03:02:36 GMT

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 _ Caitlyn

Re: power bi report server metadata

omnia_saleh — Wed, 14 Feb 2024 06:25:14 GMT

in 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

Re: power bi report server metadata

omnia_saleh — Wed, 14 Feb 2024 06:48:04 GMT

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?

Re: power bi report server metadata

josef78 — Thu, 15 Feb 2024 20:49:11 GMT

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)