How to launch a report from a dashboard
FYI I am new to this! I have a dashboard (powerbi embedded) that I want to add a report to. What I would like is for the user to be able to slice and dice the dashboard as needed, then have an 'Export' button on the dashboard that will pop-up a window that shows the associated report filtered to the user's selection. From there, the user can save the data as XLSX. I see there is a report widget, which looks like it will handle most of the above just fine, however I do not want it taking up my screen real estate all the time. Ideally the report widget would be hidden and then an export button would unhide it, and then it would hide again when the user clicks away, but I don't see that type of hide/unhide control available. Curious to see what my option are or how others launch reports from dashboards? Thanks for any ideas!!