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...
Need Help
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?