Forum Discussion

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Header Row From Web Query Columns Different

Hi all,   How can I create a header row based on data from Web Query on Fed data where table headers are inconsistent? Some fields import as a wrapped line : 2021 Jul Others import as 2 differ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    UncleLewis 

    You need to do a bit transformation in power query. Please check the power query steps in the following pbix.

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

UncleLewis 

You need to do a bit transformation in power query. Please check the power query steps in the following pbix.

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.