Table inverted from power query (why?)

[Irwin]

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 ?

[Irwin]

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]

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.

[v-xiaotang]

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.

[amitchandak]

@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