Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |