cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

data sql source

 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.

 

Ds.jpg 

 

 

 

Thanks

Erez

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Super User I
Super User I

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Thank you ! 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors