Schema Name for Tables

Hi MarioTechera 

You won't be able to see the schema because the tables loaded into or used in the model can be renamed. You can run INFO.PARTITIONS in DAX query view and filter the result to those that start with let which is what Power Query tables start with and those that contains the text Schema.

EVALUATE
FILTER (
    INFO.PARTITIONS (),
    LEFT ( [QueryDefinition], 3 ) = "let"
        && CONTAINSSTRING ( [QueryDefinition], "Schema" )
)

This would return a table that you can copy-paste to Excel.

Hello MarioTechera ,

It can be difficult to fly blind in a large model, especially when you have overlapping table names across different schemas (like dbo.customer_orders and orders.customer_orders). By default, Power BI’s diagram view focuses on the model’s logical layer rather than the source’s physical metadata. Here are couple of steps you can take :

Example : I have imported 2 tables dbo.customer_orders and orders.customer_orders

1. Using Model View : suitable for less tables

   you can check individual table properties once you have imported the tables using below steps :

   Go to model view => Select a Table => go to properties => Check name or description

2. Using Power Query Steps : This is usually the fastest way to see every table's origin at once without writing code

   Setps : go to transform data => Queries => Select a table => Go to Applied Steps => click the Navigation step ( usually  2nd  step ) => check formula bar 

3. You can also use external tools like tabular editor 

Potential Fix :  When importing from a multi-schema SQL database, rename your tables in the Power Query editor to include a prefix (e.g., dbo_customer_orders and orders_customer_orders). This keeps the schema visible in the Diagram View and the Fields list.

I hope this helps.

Did I answer your query ? Kindly mark this as solution if this helps , apprciate your kudos :).

Cheers

Neeraj Kumar