Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Julian_H
Helper II
Helper II

Lookupvalue but column doesnt exist

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

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

6 REPLIES 6
Ahmedx
Super User
Super User

pls read about append in power query

Ahmedx
Super User
Super User

Screenshot_5.pngScreenshot_2.pngScreenshot_3.pngScreenshot_4.png

Thank you works great 🙂

Greg_Deckler
Super User
Super User

@Julian_H I'm not quite understanding this scenario. Can you maybe elaborate along with some sample data?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

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

 

Julian_H_0-1691044379447.png

 

Julian_H_1-1691044551327.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.