Forum Discussion

Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
4 years ago

Button to extract all data from a table to excel

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 ...
Need Help
Irwin's avatar
Irwin
Icon for Helper IV rankHelper IV
4 years ago

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's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

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's avatar
    Irwin
    Icon for Helper IV rankHelper IV
    2 years ago

    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 😞