https://community.fabric.microsoft.com/t5/Report-Server/power-bi-report-server-metadata/m-p/3695247#M32861 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="683786" data-lia-user-login="omnia_saleh" class="lia-mention lia-mention-user">omnia_saleh</a>&nbsp;,</P> <P><SPAN>Specifically, you can use the following query to retrieve the table names and their corresponding columns:</SPAN></P> <LI-CODE lang="markup">SELECT table_name, column_name, data_type FROM dbc.columns </LI-CODE> <P><SPAN>Best Regards,</SPAN></P> <P><SPAN>Xianda Tang</SPAN></P> <P><SPAN>If this post <EM><STRONG>helps</STRONG></EM>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.</SPAN></P> Tue, 13 Feb 2024 03:14:39 GMT Anonymous 2024-02-13T03:14:39Z https://community.fabric.microsoft.com/t5/Report-Server/power-bi-report-server-metadata/m-p/3693896#M32851 <P>I have Inforamtion in a table&nbsp;[dbo].[DataModelDataSource]&nbsp; each Dashbord read from any database like (SQL Server,Teradata) i want to show tables each report read from?</P> Mon, 12 Feb 2024 11:19:30 GMT https://community.fabric.microsoft.com/t5/Report-Server/power-bi-report-server-metadata/m-p/3693896#M32851 omnia_saleh 2024-02-12T11:19:30Z https://community.fabric.microsoft.com/t5/Report-Server/power-bi-report-server-metadata/m-p/3695247#M32861 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="683786" data-lia-user-login="omnia_saleh" class="lia-mention lia-mention-user">omnia_saleh</a>&nbsp;,</P> <P><SPAN>Specifically, you can use the following query to retrieve the table names and their corresponding columns:</SPAN></P> <LI-CODE lang="markup">SELECT table_name, column_name, data_type FROM dbc.columns </LI-CODE> <P><SPAN>Best Regards,</SPAN></P> <P><SPAN>Xianda Tang</SPAN></P> <P><SPAN>If this post <EM><STRONG>helps</STRONG></EM>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.</SPAN></P> Tue, 13 Feb 2024 03:14:39 GMT https://community.fabric.microsoft.com/t5/Report-Server/power-bi-report-server-metadata/m-p/3695247#M32861 Anonymous 2024-02-13T03:14:39Z