Forum Discussion
How to paste Excel table with formatting into this forum?
Hello,
I am not sure where to post this question but i hope someone can help. Whenever i ask a question relating to some problem with Power BI, i usually provide a table or sample to illustrate and help to troubleshoot the problem that i'm having. But the issue is that table formatting is always lost. I tried to change it but when i submit the post, i always get the errror that the table HTML was changed automatically. How do i display a proper table into this forum? I usually just click and drag to select the table in Excel and copy and paste into a new post in this forum. Any help is much appreciated!
For example:
| Date | Week Number | Student Name | Submissions | Feedback |
| 03/01/2022 | 1 | Lizui | 4 | 2 |
| 06/01/2022 | 1 | Laufenburg | 7 | 5 |
| 11/01/2022 | 2 | Tegalpapak | 8 | 8 |
| 12/01/2022 | 2 | Ar Rabiyah | 5 | 6 |
| 22/01/2022 | 3 | Bellegarde | 3 | 8 |
| 21/01/2022 | 3 | Gangarampur | 3 | 3 |
| 25/01/2022 | 4 | Luntas | 1 | 1 |
| 26/01/2022 | 4 | Frei Paulo | 6 | 5 |
| 26/01/2022 | 4 | Seedorf | 2 | 1 |
| 03/02/2022 | 5 | Bellegarde | 3 | 4 |
| 05/02/2022 | 5 | Gangarampur | 3 | 7 |
| 11/02/2022 | 6 | Luntas | 1 | 2 |
| 09/02/2022 | 6 | Cosamaloapan de Carpio | 7 | 3 |
| 15/02/2022 | 7 | Zagrodno | 9 | 9 |
Every time, i see this error when i submit the post (the table formatting below is what i would like to display in my post):
Hi Anonymous ,
I copy your data above and paste it into "Enter Data" in Power BI Desktop, it is in correct table format.
And I try to copy a table from excel and paste it into here, I didn't get an error like yours.
Category 202112 202201 202202
A 100 60 80 B 80 70 90 C 90 75 95 D 75 40 70 If you always get error when you want to paste table from excel, I think you can share a pbix directly, or you can upload your excel to web like Onedrive and share it with us.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
I copy your data above and paste it into "Enter Data" in Power BI Desktop, it is in correct table format.
And I try to copy a table from excel and paste it into here, I didn't get an error like yours.
Category 202112 202201 202202
A 100 60 80 B 80 70 90 C 90 75 95 D 75 40 70 If you always get error when you want to paste table from excel, I think you can share a pbix directly, or you can upload your excel to web like Onedrive and share it with us.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.