Forum Discussion

omnia_saleh's avatar
omnia_saleh
Helper II
2 years ago

power bi report server metadata

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?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.