Helper Queires

[dantheram]

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 i do this?

thanks

Dan

[Ehren]

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

[dantheram]

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]

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