Forum Discussion

dantheram's avatar
dantheram
Icon for Helper II rankHelper 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

Need Help

3 Replies

  • Ehren's avatar
    Ehren
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper II rankHelper 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
        Icon for Microsoft Employee rankMicrosoft Employee
        4 years ago

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