Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Irwin
Helper IV
Helper IV

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).

Irwin_0-1646222517498.png

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

Irwin_1-1646222617084.png

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

Irwin_3-1646222684155.png

 

 

4 REPLIES 4
Irwin
Helper IV
Helper IV

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.

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
Community Support
Community Support

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
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.