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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
ShrimpCreole
Helper I
Helper I

Adding Query Name as Column In Power Query

How / where in Power Query advanced editor would I add the name of the query name?   B

 

let
Source = GoogleAnalytics.Accounts(),
#"250012481" = Source{[Id="250012481"]}[Data],
#"UA-195155603-5" = #"250012481"{[Id="UA-195155603-5"]}[Data],
#"268254880" = #"UA-195155603-5"{[Id="268254880"]}[Data],
#"Added Items" = Cube.Transform(#"268254880",
{
{Cube.AddAndExpandDimensionColumn, "ga:channelGrouping", {"ga:channelGrouping"}, {"Default Channel Grouping"}},
{Cube.AddAndExpandDimensionColumn, "ga:deviceCategory", {"ga:deviceCategory"}, {"Device Category"}},
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddMeasureColumn, "Goal Completions", "ga:goalCompletionsAll"},
{Cube.AddAndExpandDimensionColumn, "ga:source", {"ga:source"}, {"Source"}},
{Cube.AddAndExpandDimensionColumn, "ga:sourceMedium", {"ga:sourceMedium"}, {"Source / Medium"}},
{Cube.AddAndExpandDimensionColumn, "ga:sessionCount", {"ga:sessionCount"}, {"Count of Sessions"}},
{Cube.AddAndExpandDimensionColumn, "ga:userType", {"ga:userType"}, {"User Type"}},
{Cube.AddMeasureColumn, "Pages / Session", "ga:pageviewsPerSession"},
{Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"},
{Cube.AddMeasureColumn, "Bounce Rate", "ga:bounceRate"},
{Cube.AddMeasureColumn, "Bounces", "ga:bounces"},
{Cube.AddMeasureColumn, "Hits", "ga:hits"},
{Cube.AddMeasureColumn, "Session Duration", "ga:sessionDuration"},
{Cube.AddMeasureColumn, "Sessions", "ga:sessions"},
{Cube.AddMeasureColumn, "New Users", "ga:newUsers"},
{Cube.AddMeasureColumn, "Users", "ga:users"}
})
in
#"Added Items"

1 ACCEPTED SOLUTION
sevenhills
Super User
Super User

Not sure your needs, A little long way, but you can get it.
Check this link

https://radacad.com/get-list-of-queries-in-power-bi

 

View solution in original post

1 REPLY 1
sevenhills
Super User
Super User

Not sure your needs, A little long way, but you can get it.
Check this link

https://radacad.com/get-list-of-queries-in-power-bi

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.