Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
adamgor
Microsoft Employee
Microsoft Employee

What is the source of my dataset tables?

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?

 

1 ACCEPTED SOLUTION
adamgor
Microsoft Employee
Microsoft Employee

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

View solution in original post

5 REPLIES 5
adamgor
Microsoft Employee
Microsoft Employee

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

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).

 

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

 

SourceStep.PNG

 

 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.

 

SourceCode.PNG





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

Proud to be a Super User!




@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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thanks guys for helping me get this small thing solved 🙂

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.