The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
Is it possible to write a query that extracts all column names and datatype for a table in Power BI?
Desired output is a table with two columns, columnname and datatype.
Solved! Go to Solution.
Yes. Please see the Table.Schema function.
Table.Schema - PowerQuery M | Microsoft Learn
Pat
Is it possible to get it for all the tables at the same time?
Yes. Please see the Table.Schema function.
Table.Schema - PowerQuery M | Microsoft Learn
Pat