Unanswered

Refresh Button to specify which Report/Dataset to refresh.

(0) Share

Report

Posted on by rollyvalenzuela

1st time to be here in Power Automate Community. Came all the way from Power BI Community.

I don't know if this is a Power Automate question or a Power BI question.
For context I do have a requirement to place a button in a Power BI report and have the ability to refresh the Dataset
( I know Power Automate can do it )

The interesting part is.

This Dataset set is getting all the datasetIDs from a Power BI Rest API and eventually stored in table in the Datawarehouse.
The goal is to have the ability to refresh a specific report using the button. So, if I want to refresh Dataset 1 out of the 10 Datasets
I can do it smoothly by clicking a button and move to another Dataset I want. Which Perhaps an option between to select which report I want to refresh and click the button to execute.

Any idea on how I can execute this?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

RajputAli_007 7 on at

Like (0)

Report
Copy link

Link copied!
Certainly! To achieve this, you can create a Power Automate (formerly known as Microsoft Flow) flow that takes the selected dataset ID as input, and then use the Power BI REST API to trigger a refresh for that specific dataset

Here's a step-by-step guide on how you can set this up:

Create a Flow:
Go to the Power Automate portal: https://flow.microsoft.com/.
Click on "Create" and choose "Instant - from blank" to create a flow that can be triggered manually.
Add a Button Trigger:
Add a "Button" as the trigger. This will be the button you click in Power BI to initiate the refresh.
Add a Manual Input for Dataset ID:
Add an action to get user input. For example, use the "Manual - Input" action to ask the user for the dataset ID.
Add an HTTP Action to Refresh Dataset:
Add an action to make an HTTP request. Use the "HTTP" action and configure it to send a POST request to the Power BI REST API for dataset refresh.
The URL will be something like: https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes
Replace {groupId} and {datasetId} with appropriate values. You can get these from your Power BI workspace and dataset.
Configure Authentication:
In the HTTP action, you need to set up the authentication. Use the "Authentication" header with an access token. You can get an access token by setting up a connection to Power BI in Power Automate.
Testing:
Test your flow to make sure it successfully triggers a refresh for the specified dataset when the button is clicked.
Use in Power BI:
Now, you can use the "Power Automate" connector in Power BI to call this flow. Add a button in your Power BI report and use the "Power Automate" action to call this flow, passing the dataset ID as a parameter.
Parameterize the Dataset ID:
In the Power BI report, you can create a parameter for the dataset ID. This parameter can be used to dynamically set the dataset ID when the button is clicked.
By following these steps, you should be able to create a Power Automate flow that can be triggered by a button in Power BI to refresh a specific dataset based on the user's input.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
rollyvalenzuela 2 on at

Like (0)

Report
Copy link

Link copied!
@RajputAli_007 - Thank for the steps.

Quick question please

Configure Authentication:
In the HTTP action, you need to set up the authentication. Use the "Authentication" header with an access token. You can get an access token by setting up a connection to Power BI in Power Automate.

Not quite sure if there is an option for it. I was trying to look for a header with an access token.
Did I miss anything?

Was this reply helpful? Yes No