power bi report server metadata

[omnia_saleh]

I have Inforamtion in a table [dbo].[DataModelDataSource]  each Dashbord read from any database like (SQL Server,Teradata) i want to show tables each report read from?

[Anonymous]

Hi @omnia_saleh ,

Specifically, you can use the following query to retrieve the table names and their corresponding columns:

SELECT table_name, column_name, data_type
FROM dbc.columns

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.