Button to extract all data from a table to excel

[Irwin]

Hi Everyone,

I am looking for a way to create a button that extracts all data from a certain table to a downloadable excel file.

If possible I would love that the selected filters/slicers would be applied to the download.

Is any such thing possible? 

Thank you for all assistance 🙂

[Tahreem24]

@Irwin Try this videos to get some idea on exporting using button:

https://www.youtube.com/watch?v=sd3YCjN8Co4

https://www.youtube.com/watch?v=BnTipbooeP0

[Irwin]

Thank you very much! This might be what I am looking for. I will need to watch your vids and educate myself a little. I hope I can get it to work 🙂

[mh2587]

You can just do this from clicking the three dots in the right top corner of the visual and select export data

[Irwin]

Hi mh2587,

Yes thank you. However that is just from one figure? I would like to just make a button that would extract the entire table (approx 100 columns and alot of rows)

[croberts21]

I'm not sure what you mean by "figure".

If you go to a viz, click the 3 dots, and export to an Excel file your Excel file contains only the columns and rows the viz shows you.

[Irwin]

Hi Croberts,

Okay. Maybe I was bad at expressing myself.

A visual can only contain the data you supply to it. So if I extract something from a line chart it gives me what I put in to create the lines.

I want a button that downloades an excel sheet containing the entire table (with all columns). 
I suppose I could create a table with all my columns... but I have 100 and it would look "ugly" in the report.

It would also not be as user friendly for the end user to "click the three dots". The people I am developing this for have a hard time just clicking a button with instructions. 

I would like a button that says "Data" and once clicked an excel sheet is auto downloaded to their download folder containing the entire table I have created my 50+ visuals from.

[Syndicate_Admin]

Hello.

Have you been able to download the full data table using a button?

I saw the videos above, but these go to a sharepoint.

If you could guide me on how it is possible that you did it.

Thank you for your support.

[Irwin]

Unfortunately I never got it to work. I ended up using some sort of power automate code that could partly extract tables. However I cannot remember what I did since it was not an optimal solution and thus was never really used.

Sorry 😞