Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a requirement wherein I need to take user input in Power BI service and show the result in the same report instantly. I have tried using Power App but the data in the report is not refreshing. I also tried to include a Power Automate flow but it also did not help.
Since the user can input any decimal value, I cannot use the What if parameter. Please suggest any other ways to achieve this.
Thanks,
Arunima.
The only way we have found so far is a PowerApps visual combined with a Direct Query data source (SQL Server in our case). It is very close to real time (a couple seconds max) but it requires all report users to have a PowerApps Premium license (since the SQL Server connector is considered Premium). It also requires a gateway conenction with a user that is allowed to write to the database.