Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 a...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.