data sql source

[erezb]

 Hello

Why Can't I see the table name in sql data source.

As you can see when connecting to excel Datasource I see full path.

In the sql connection I get only the DB name (tichnun).

It's helpful to know the table name when changes are needed in the table creation process inside Sql.

 

Thanks

Erez

[KHorseman]

Individual queries may select from one or more tables. The data source/connection isn't a single table; it's the database. If you want to see navigation to a specific table you'll need to look at the query that uses it.

[erezb]

hi

again

I have entered the query editor. In the right side I see "name" ' but this field can be edited so it doesn't correspont neccessarily

to the table name from where the data was imported.

Have you meant this field or is there another location when I can see the table name?

Thanks again

Erez

[KHorseman · Accepted solution]

No, that's the name of the query, and the name of the resulting table in your Power BI data model. The name of the table is found in the navigation step of the query. The query steps are below the query name on the right hand side.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-query-overview/

[erezb]

Thank you ! 

[KHorseman]

Or to put it another way, a data source is just a connection to a database. It isn't the data itself. It's the phone line, not the conversation.