Forum Discussion
omnia_saleh
2 years agoHelper II
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
- AnonymousNot 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.columnsBest Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.