Hi, I am creating another query from an excisting table in my model I have managed to bring ONE column only, but I don't know the syntax to bring more columns, how can I do it?
ONE COLUMN
= #"LND_SPF_PDREPORT"[Qtr Year Query]
MULTIPLE TRY
= #"LND_SPF_PDREPORT"[Qtr Year Query],[COLUMN 2],[COLUMN 3] = ERROR
= #"LND_SPF_PDREPORT"[Qtr Year Query,COLUMN 2,COLUMN 3] = ERROR
= #"LND_SPF_PDREPORT"[Qtr Year Query],"LND_SPF_PDREPORT"[COLUMN 2] = ERROR
It would be easier to reference your existing query, select the columns you want and then right click and choose 'Remove other columns'. Don't forget to remove duplicates if that is important.
See gif.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
It would be easier to reference your existing query, select the columns you want and then right click and choose 'Remove other columns'. Don't forget to remove duplicates if that is important.
See gif.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Helpful resources
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
