how to create a button to let user click only once a day

[oakfootballclub]

hi experts, there is a situation that users are allowed to download a limit rows of data let's say 100 rows a day, do you know how to make it? My idea is that close the export and add a button that can export data but the button can work only once a day, but I don't know how to make it, or do you have other solutions? Thank you.

[Shravan133]

Disable Default Export

In the Power BI Service, you can control the export settings for a report:

• Go to the Report Settings and disable the default export feature for all users or a specific group.

2. Create a Custom Export Button

In Power BI, you can create a button that triggers a Power Automate flow to export the data. The flow will handle the row count limit and user restrictions.

3. Power Automate Flow to Export Data

Steps for the Power Automate flow:

1. Button Trigger: The flow is triggered by a button click in Power BI (Power Automate Visual).
2. Fetch Data from Power BI: The flow uses a Power BI REST API or a query to fetch the required data.
3. Limit the Number of Rows: The flow can be configured to retrieve only 100 rows from the Power BI dataset.
4. Check Export Activity: Use a storage mechanism (e.g., SharePoint, a database, or a simple table in Power BI) to track the export activity by user and date. This allows the flow to verify whether the user has already exported data for the day.
   • If the user has already exported data, the flow can return a message denying the request.
   • If the user has not exported data, it proceeds to export and logs the activity.
5. Export the Data: The flow can save the data in a CSV or Excel file and email it to the user, or store it in a shared location (e.g., SharePoint or OneDrive).

Example of Flow Logic:

• Condition: Check if the user has already exported data for the day using the email or user ID.
• Action: If they have not, retrieve up to 100 rows of data and send the file. If they have already exported data, display a message indicating the limit has been reached.

4. Add the Power Automate Button in Power BI

Once the Power Automate flow is ready:

• Go back to Power BI Desktop and add the Power Automate Visual to your report.
• Link the button to the Power Automate flow.
• Customize the button text (e.g., "Download Data").

Example Power Automate Flow Logic:

1. Trigger: Button click in Power BI.
2. Condition: Check the last export date for the user (e.g., via SharePoint or a database).
3. Action: If the last export was today, return a message. Otherwise, fetch the data from Power BI.
4. Fetch Data: Query the dataset with a limit of 100 rows.
5. Export: Create and send a CSV or Excel file.
6. Log Activity: Update the export log for the user.

[oakfootballclub]

Thank you for you answering, it seems create a button via power automate and then it works, so is the button can be slicked once a day per user? can you gave an example for it? Thank you.

[lbendlin]

Ignore the ChatGPT answer. Drop your requirement.

[lbendlin]

Thankfully that is not possible. That would be a really bad user experience.