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

 

thanks

Dan

3 Replies

  • Ehren's avatar
    Ehren
    Microsoft Employee

    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

      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

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