Forum Discussion

Irwin's avatar
Irwin
Helper IV
4 years ago

Table inverted from power query (why?)

Hi guys,

 

My data is from an excel sheet. The table looks like the below in power query (top left corner snip).

When I look at the table in power bi the data is inverted... below can be seen a snip of the top left corner.

My data is all the way at the bottom (see sliders) ... why ?

 

 

Need Help

4 Replies

  • Irwin's avatar
    Irwin
    Helper IV
    4 years ago

    Hi Guys,

     

    Thank you for your answers. I am not able to share more sadly. It is confidential. I would need to change to much data for it to be worth the time.

     

    v-xiaotang No. I mean that it is correctly displayed in the excel sheet (data is in A1,A2,B1,B2 and so forth), it is similary correctly displayed in the power query, however, once I close the power query it shows up inverted in the power bi data window.

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      4 years ago

      Hi Irwin 

      Thanks for your reply.

      Click refresh in Power BI Desktop, and restart it.

      If this doesn't help, please contact us again. Thanks.

       

       

      Best Regards,

      Community Support Team _Tang

      If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Irwin , With three screenshots, I am not able to relate to your problem. check steps in power query if some step as caused this order changes

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Irwin 

    Do you mean your table is inverted in Power Query after you import it from Excel file? Could you share a sample file for us to test? Thanks.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.