Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Icon for Helper V rankHelper V
5 years ago
Solved

Selected Data Copy paste in to Excel

Hi Experts,

Is there a way to select the selected data in PBI and import into Excel?

I know we can do in Flat file but how can we do if it non flat file or need to select specific columns and paste in to excel something like that

 

Thanks in Advance

Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Sudhavi_84 not possible, for this you need to use a paginated report, and that required minimum a PPU license.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    Sudhavi_84 not sure there is an easy way to do this. You can add required columns in a table visual, filter the table based on what you need, and then use export. I'm afraid if there is a cut/paste option. From table view, you can copy the data but you don't have a choice of columns.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Sudhavi_84's avatar
      Sudhavi_84
      Icon for Helper V rankHelper V
      5 years ago

      Not from a Table View, 

      Lets say I want to copy the data from Matrix visual with selected data only. Can I do it?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    Sudhavi_84 not possible, for this you need to use a paginated report, and that required minimum a PPU license.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡