Forum Discussion

irfan_abdrhman's avatar
irfan_abdrhman
Icon for Helper II rankHelper II
2 years ago
Solved

Sharing the Table View and Report View. Able to export to Excel

Hi Community, I want to know how do I export the information of the Dashboard into Excel. I want the data from Table View/ Power Query and also the filter-able Dashboard in the Report View to be extr...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi irfan_abdrhman 

     

    If I understand correctly, you want to export the full data in the table view/Power Query in Power BI desktop, and then export the filtered data in the report view in desktop?

     

    The following test is for your reference:

     

    My sample:

     

    Report View:

    I then filtered as shown.

     

     

    Output:

     

    According to my test, it seems that it is not possible to export data from table view or Power Query to Excel. You can create a visualization table with complete data and then repeat the above steps.

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    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
2 years ago

Hi irfan_abdrhman 

 

If I understand correctly, you want to export the full data in the table view/Power Query in Power BI desktop, and then export the filtered data in the report view in desktop?

 

The following test is for your reference:

 

My sample:

 

Report View:

I then filtered as shown.

 

 

Output:

 

According to my test, it seems that it is not possible to export data from table view or Power Query to Excel. You can create a visualization table with complete data and then repeat the above steps.

 

Output:

 

Best Regards,
Yulia Xu

 

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