March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi, I am trying to set up a table where not all the columns are present in the source table.
example
Col 1, Col 2, Col3,Col4
Source data only has Col1 and 3
So I want populate Col and 3 with the data and leave the other blank
I have tried in M Query and it takes over 30mins to load 50 columns
I have also tried in Dax lookupvalue , but as the column doesnt exist in the source file it errors.
Is there a way to subdue this error
or is there a better way to do this
Thank you
Solved! Go to Solution.
pls read about append in power query
Thank you works great 🙂
@Julian_H I'm not quite understanding this scenario. Can you maybe elaborate along with some sample data?
Apologies,
I have a template table with all the columns I need in,but the source file only has a few of these columns.
How do I populate the template with columns that are available in the source file and leave all the other blank
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
86 | |
82 | |
76 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |