Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Exporting multiple tables together to csv

Hi,   I have multiple small tables in a published dashboard. I want to allow users to download the tables all at once but not by clicking on each table individually. I want a way with which these c...
Need Help
Burningsuit's avatar
Burningsuit
Resident Rockstar
4 years ago

Hi Anonymous 

You can probably do this by using a Paginated Report, pulling data from the Dataset and buiding a combined report that can then be downloaded as an excel or csv file:

See..Paginated reports in the Power BI service - Power BI | Microsoft Docs

These Paginated Report doownloads can be accessed via a button in a power BI Report:

See..Export data with Power BI Paginated URL Parameters - Guy in a Cube

Note that you'll need a Premium Per User or better licence to run these Paginated Reports.

If you only have a Pro licence, the new "Exportable Formatted Tables" in Data Hub gives something like the same feature set, however you currently can't use parameters or automate the download:

see..Exportable Formatted Data Tables (Preview) | Microsoft Power BI Blog | Microsoft Power BI

Hope this helps

Stuart

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for your response. The issue is I cannot combine these individual tables into a single table because each of these are created using different slicers and formulas.