What is the source of my dataset tables?

[adamgor]

I am using the PowerBI desktop client and I have a dataset with about 10 sources. 

However they are a mixture of local excel files, local csv files, and remote SQL database connections, and remote shared group drive locations.

However we are migrating to not have any local files be connected anymore and I don't know which ones are local and which one are remote.  I am trying to unify them, I can't seem to figure out which one is connecting to SQL vs which one connects to a local file.

Is there a way to identify where/what is powering a table in a dataset?

[adamgor · Accepted solution]

I resolved it myself, at least in a way that is seemingly good enough for now.

Edit Queries > Click Table > Click Source 

and I could see the SQL table name

[adrien5555]

Hey Adamgor, 

Same problem, but can"t find any "Source" button... could you precisz where you find it, in the Query Editor, please?

note : I look for CSV files (need folder) or web files (need the link).

[KHorseman]

I believe he is referring not to a button, but to the "Source" step in the query editor.

 Click on that and look in the formula bar to see the code for the source step, which tells you what the source is and where it is located.

[Seth_C_Bauer]

@adrien5555 you can also click on "Advanced Editor" in the top ribbon of the Query Editor, this displays a pop up of the "M" code which references the data source. This is the same as clicking the "Source" in applied steps, but just gives you more screen real estate.

[adrien5555]

Thanks guys for helping me get this small thing solved 🙂