Power BI Service dashboard - button that runs a Python script?

[Dimani]

Hi,

We have a Python script that gets data from one database, transforms the data, and loads the data into SQL Server.  We are planning to use Windows scheduled task to run it.

But, would it also be possible to add a button on a Power BI Service dashboard that runs the Python script mentioned above?

Thank you,

[Dimani · Accepted solution]

Hi Vinay,

I created a Power Automate Desktop flow that runs the Python script.  However, to be able to add it to the Power BI Service report, we need a premium license, that we do not have.  I have not gone further than that.  

Perhaps somebody else who have a premium can confirm whether it is a solution or not.

Thanks.

[v-vpabbu]

Hi @Dimani,

As we haven't heard back from you, At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

Thank you for being part of the Microsoft Fabric Community. 

Regards,

Vinay Pabbu

[v-vpabbu]

Hi @Dimani,

Thanks @lbendlin for Addressing the issue.

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[lbendlin]

Dashboards are not interactive - you cannot press buttons on them (except maybe when you pin an entire report page to a dashboard tile).

Did you mean Report?  Consider using the "Power Automate"  visual instead, or consider not doing this at all. Because - when you give users a button they will smash it, and you will end up with hundreds of these script running all in parallel and trashing your database.

[Dimani]

Yes, report.  We are considering doing this for the just in case scenario, when the scheduled job does not work unexpectly.  Users will have a way to run it instead of waiting for the admin to look at it.

You made a very good point that what if multiple users run the script at the same time.  Will keep that in mind.

Thanks for pointing out Power Automate visual.  Will look into it to see if that's something we can use.

Best regards