Forum Discussion

dantheram's avatar
dantheram
Helper II
4 years ago

Helper Queires

hi   i have a series of helper quieries that are looking up column names, my excel import files are always the same in terms of headers so i believe these helper queiries can be removed, but how do...
Need Help
Ehren's avatar
Ehren
Microsoft Employee
4 years ago

Can you replace any references to the helper queries with hard-coded versions of the info that the helper queries would have returned?

dantheram's avatar
dantheram
Helper II
4 years ago

hi 

 

PowerBI is creating them automatically and all they do is move the first row to be column headers, but i don't know how to fix - i'm a novice, apologies 

  • Ehren's avatar
    Ehren
    Microsoft Employee
    3 years ago

    Hm, okay. But if the header promotion step is working correctly, what's the issue?