Forum Discussion

Irwin's avatar
Irwin
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper 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
Icon for Community Support rankCommunity 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.