Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I've tried to create a table with the number of rows of every table in my Power BI report (with some exceptions) using Power Query:
let
#"Section1" = #sections[Section1],
#"TableList" = List.Select(Record.FieldNames(#"Section1"), each not (Text.Contains(_,"Nøgletal:") or Text.Contains(_, "Aktuel rapport") or Text.Contains(_, "Tabeloversigt"))),
#"RowCount" = List.Transform(#"TableList", each Table.RowCount(Expression.Evaluate("#""" &_& """", #shared))),
#"Table" = Table.FromColumns({#"TableList", #"RowCount"}, {"Table Name", "Rows"}),
#"Changed type" = Table.TransformColumnTypes(Table,{{"Table Name", type text}, {"Rows", Int64.Type}})
in
#"Changed type"
It works perfectly fine in the Power Query-editor and is (in this case) looking like this:
But when I try to apply the changes, I get an error per row in the table, and the Rows-column is empty. When I try to see the error in Power Query-editor, the error table is empty:
Any idea what I'm doing wrong?
👀
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
41 | |
23 | |
21 | |
20 | |
13 |
User | Count |
---|---|
128 | |
58 | |
48 | |
28 | |
20 |