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