Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi Everyone,
I was wondering if anyone knew a way to get the source Table Name from a query using a SQL server source. What I'm trying to do is filter another query based on the source table name from the first query using power query functions or m code.
Is there some kind of property that would return the source table name for a given query? Or some other creative way to get the name?
Any help would be appreciated and I thank you in advance.
Solved! Go to Solution.
Hi @Powerbinewguy20
Below M code will give you the table name.
let
Source = Sql.Databases("Seneca"),
TableName = Table.ToRecords(Source){0}[Name]
in
TableName
Below is the source step.
Let me know if this helps.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
LinkedIn
Hi @Powerbinewguy20
Below M code will give you the table name.
let
Source = Sql.Databases("Seneca"),
TableName = Table.ToRecords(Source){0}[Name]
in
TableName
Below is the source step.
Let me know if this helps.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
LinkedIn
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |