Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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
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.
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.
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.
Thanks guys for helping me get this small thing solved 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |