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.
- 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).
- In Power BI, connect to that table. Power BI can read the table where the user’s selected date is stored.
- 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.
- 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.
