Forum Discussion
Helper VComplete beginner failing to create table in Power BI with #Table command.
Hello folks,
Complete beginner here. I am trying to learn the Power Query M language through simple excercises, like this one explaining how to create a simple table through a query:
1 | #table({"First Column", "Second Column"}, {{1,2},{3,4}}) |
However, whatever I do in the query editor, the M code is just pasted as content into a 1x1 table instead of actually creating a table. What am I doing wrong? Please ELI5.
Cheers, Mike
2 Replies
Jimmy801Community Champion
Hello h4tt3n
everyone has began once at this point.. so... don't worry.
The code is fine... post it in the advanced editor like this
and the result will be like this
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
h4tt3nHejjo Jimmy801,
Okay, now I got it working. It seems I hit into a formatting and hidden character problem when copy/pasting from the web. This is what got pasted into my query equation bar:
= "#(tab)#(cr)#(lf)#table({""First Column"", ""Second Column""}, {{1,2},{3,4}})"
Once I weeded out all the extra stuff it worked just fine! Thanks!
Cheers, Mike