No Rows in Table but rows in Query editor

[angelakephart]

Hi,

I have multiple queries that pull pageviews and dates from our websites.  When I append the queries and close and apply I can see rows in the table view.  What I wanted to do was capture the name of the query along with the rows, so I used the below script.  In this new query I can see all of the rows in query mode but once I close and apply the table view shows no rows.  What is happening...

let
Query1 = #shared,
#"Converted to Table" = Record.ToTable(Query1),
#"Filtered Rows" = Table.SelectRows(#"Converted to Table", each Text.Contains([Name], "www")),
#"Expanded Value" = Table.ExpandTableColumn(#"Filtered Rows", "Value", {"Date", "Pageviews"}, {"Date", "Pageviews"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Value",{{"Date", type date}, {"Pageviews", Int64.Type}})
in
#"Changed Type"

[v-danhe-msft]

Hi @angelakephart,

I have tested with your code and it show nothing in the query editor:

I would like to know if you have tried use any functions before? Could you please offer the pbix file to have a view?

Regards,

Daniel He