Forum Discussion

omnia_saleh's avatar
omnia_saleh
Icon for Helper II rankHelper II
2 years ago

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?
Power BI Report Server
josef78's avatar
josef78
Icon for Memorable Member rankMemorable Member
2 years ago

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)