Forum Discussion
Export Summary Table
Maybe I am missing something simple, but after editing in the query, I am not seeing how to export once the data is manipulated how I want it.
Hi Anonymous,
You can apply the modification in Query Editor then close. Back to the report, you can see Export-> Power BI template.
Reference:
Deep Dive into Query Parameters and Power BI Templates
Best Regards,
Qiuyun Yu
Recieved errors when filtering in edit queries screen. Figured out a way to get this done.
Created a calculated table based on the old data with a filter
Right click the table on the right side, and select copy table
Paste into a text file
Load text file
It works and will be fine, still looking for a better and more efficient way though since we will have to update these.
Hi Anonymous,
Another available way is to put all table fields into a table visual and set visual level filters, then export data. See: Export data from Power BI visualizations.
Best Regards,
Qiuyun YuBut this only works for up to 30,000 lines, correct?