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!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
90 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |