Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

columns displaced in PBI Data view

Hi,

I have a problem with my colmns moving after I close and apply Power Query as shhown in these pictures:

 

How I can fix it and avoid it happening again?

Show and Tell
Tips and Tricks

5 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    What steps did you apply?

    Could you share some code in Advanced editor so that i can reproduce it and find the reason?

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-juanli-msft  Thanks!

      Actually I just got the table from Excel and did some cleaning in Power Query as the following pic:

       

      Please see the above screenshot v-juanli-msft 

      Thanks

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    Is the second picture in Data view or in Power query?

    If it is in Power query, drag this column and move it.

    If it is in Data view, i can't reproduce your problem.

    Could you show me an simple test file via OneDrive link?

    (enter data by "Enter data" so that i can steps or code in Edit queries)

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-juanli-msftthanks!

      in the first post, the upper picture is showing it in Power Query view and the lower picture is in Report View, I was wondering why the two column displaced?

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        I can't reproduce your problem.

        Does the first screen show when you click on Promoted headers on APPLIED STEPS pane?

        when you nagivate from Power Query view to Report View, do you click on "apply&&close"?

         

        If you click on "apply&&close", the picture in Report View should show the same as picture on last step "Renamed Column1" in Power Query view.

         

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.