Forum Discussion
Can we have functionality like web application in Power BI?
As per the requirement, user should be provided with a text box and Search button on the report. On the text box, user is supposed to enter an email. Based upon the user input, it should trigger Po...
Hi AnkitSingla ,
It could be achieve using PowerApp custom visual. The search box and button should be created in the PowerApp. Using PowerAutomate you can invoke PowerShell script with the help of AzureFunction. Once you have the result data, you can temporarily save it in Azure SQL along with your login id (login id is required for RLS). When you pass a new email address in the PowerApp, you can replace the existing result. This table needs to be connected to PowerBI using DirectQuery mode. With the help of RLS, you will see only your query results from the temporary table.
Regards,
Nandu Krishna
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍
Nandu Krishna
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍
Proud to be a Super User!