CODEWITHSUNDEEP
powerbipowerquerym
Clayton Tosatti
Clayton Tosatti

Reputation: 196

Find the default table name after rename

I have a file in PowerBI that contains some tables all linked to SQL SERVER. My problem is this:

To make user use easier I renamed the tables to a friendlier name, but now I need to know the actual name of the table in the database and I can not find this data.

Where can I find this?

Upvotes: 1

Views: 316

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40214

Go your query editor and open the Advanced Editor for a query that links to the server.

In the first few lines of the M code, you should be able to see exactly how it's connecting and what the SQL table name is. It might look something like this:

let
    Source = Sql.Databases("servername"),
    DatabaseName = Source{[Name="DatabaseName"]}[Data],
    TableName = DatabaseName{[Schema="dbo",Item="TableName"]}[Data],
<...>

Upvotes: 1

Related Questions