Can end users Input parameters in a Power App form and pass it to a Power BI query ?

[nvalPBI]

I am working on a report where I need to pass a date field  to sql query to pull data for the POwer BI report.  Currently date is hard coded and I would like  to change it to a variable which accepts values from a end user through a front end screen or form.  Can I design a power app form with an option to capture the user entered date value ?  and pass it to Power BI query to get the desired set of data.  How to Integrate Power APPs to Power BI to accomplish thsi task. Please help

[v-agajavelly]

Hi @nvalPBI ,

I’m following up to confirm that all items discussed have been addressed. If there’s anything else you need, I’d be happy to assist.

Regards,
Akhil.

[nvalPBI]

Thank you for checking on the status. I created a Power Automate workflow with PowerApps as the trigger. When I run the flow the powerapps screen comes up with an input prompt for Term date and once I enter the date , the flow runs to update a share point list. This is working fine.  I am able to read the sharepoint list from Power BI , but not sure how can I plug in that value in the SQL query in Power BI which is the source . If you can help me , that would be great.

Thank you very much 

[v-agajavelly]

Hi @nvalPBI 

Just checking, Were you able to try out any of the suggestions shared earlier? If your issue is resolved, marking the accepted solution would be a big help to others who might be facing the same scenario.

If you went in a different direction or still need support, feel free to drop a quick update, we’re happy to keep helping.

Regards,
Akhil.

[v-agajavelly]

Hi @nvalPBI 

To pass a date from Power Apps → Power Automate → Power BI:

1. In Power Apps
• Add a Date Picker
• Add a Button to submit
• Connect the button to a Power Automate flow
• Pass the selected date to the flow
2. In Power Automate
• Use the Power Apps trigger
• Add a step to insert the date into a SQL table (like UserInputTable)
• Then, add a step to refresh your Power BI dataset
3. In Power BI (Power Query)
• Read the date from that SQL table
• Use it in your SQL query like this.

Here’s what your Power BI SQL query might look like.

WHERE OrderDate = (SELECT TOP 1 UserSelectedDate FROM UserInputTable ORDER BY ID DESC)

 
--------------------------------------------------------------------------------------------------------
If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.

Regards,
Akhil.

[nvalPBI]

Thank you for the step by step instructions on how to accomplish this process.  I would like to do it real time using a power automate flow.  Direct query is not possible in my environment. Do you have any code examples for passing parameters from PowerApps - Power Automate - Power BI SQl query ? 

[v-agajavelly]

Hi @nvalPBI 

Yes, you can let users enter a date in a Power App form and use that in Power BI to get specific data. Here’s how it works, in easy steps.

You don’t want to hardcode a date anymore. Instead, you want users to type or pick a date in a form, and then Power BI should use that date to pull the right data.

Try Build a simple form in Power Apps
Add a Date Picker control this lets users choose a date easily.

1. When they submit the form, save that date. You can save it in something like. A SQL table (best if your data is already in SQL), A SharePoint list, A small Excel file on OneDrive, Or Dataverse (if you're using Microsoft’s Dataverse).
2. In Power BI, connect to that table. Power BI can read the table where the user’s selected date is stored.
3. Use that date inside your SQL query or filters. When Power BI loads data, it can read the user-entered date and apply it in the SQL or DAX logic to show only the relevant results.
4. Make it real-time (optional). If you want it to instantly update Power BI when the user picks a new date, you can use DirectQuery or a Power Automate flow to refresh Power BI right after form submission.

After You have a clean form that says.  “Please choose a date to load the report”

The user picks June 1st. You press submit. Boom Power BI loads data just for June 1st. And remember no more editing queries manually.

------------------------------------------------------------------------------------------------------------------------------
If this solution works for you, please consider marking it as accepted so others facing a similar issue can benefit too.

Regards,
Akhil.