Need to filter dashboard and save as image in automatic mode

[Yonko]

Hi there, today I came here with the next problem.

I have a dashboard with a visual which shows data for users. There is also a filter for users, so you can select different users and visual will show different data.

And now comes the problem - our Client wants to implement the next functionality: user in Telegram should paste their name to the bot and then it somehow should be transfered to PBI and be filtered by it (usernames will be the same as in filter), and after it filtered visual should be transfered back to the user (image or PDF will also works). So it's like to open the dashboard, filter user, make a screenshot or save as PDF and send it back to user - but because there will be lots of users it'll be tedious and Client wants to automate it.

There is a function to filter dashboard by URL, so if username could be inserted in a link the dashboard will be correct, and then the Client just need to save it as PDF and sent back to user - but I don't know how automate saving. Another option would be just give the link back to user, but because they aren't from company they won't have access. And we can't apply these link manipulations with the public URL.
So, if anyone have some ideas how to make this functionality I'll be very grateful.

Have a nice day anyway.

[ribisht17 · Accepted solution]

@Yonko 

Option 1: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export

Option2:

https://dataap.org/blog/2022/03/10/export-power-bi-report-visual-as-a-image-rest-api-automated-way/

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[lbendlin]

I have a dashboard with a visual 

What you have is a report.  A dashboard is something different.

Theoretically you could have an API call that would request an export of your filtered report as a PNG or PDF. However that will be very slow as the render request will be put in the queue, and then it may or may not be worked on straight away, so your API caller will need to poll the service to ask "are you done yet" repeatedly, and once complete would have to fetch the resulting file.  

So yes, this can be automated but the user experience will be horrible.