Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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/
Proud to be a Super User!
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.
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/
Proud to be a Super User!
Thank you !
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |