Refresh Webpage with button in Dashboard

Hi LYorkToenniges,

In Power BI, HTML code like <button> or JavaScript (e.g., window.location.reload()😉 cannot be directly embedded or executed. Power BI does not support interactive scripting within visuals or buttons because it prioritizes security and sandboxing of reports.

However, there is an alternative solution to achieve the functionality of refreshing visuals or generating new responses:

Alternative Approach: Simulate Refresh with a Dynamic Visual
Instead of trying to program a refresh button using HTML/JavaScript, you can use measures with randomization and toggle slicers/buttons in Power BI. Here's how you can implement this:

Steps to Create a "Refresh" Effect:

1. Create a Random Measure: Use a DAX measure that generates a random value each time the visual is refreshed or recalculated.

   • RandomValue = RAND()

   • This measure will generate a new random number every time the report is recalculated (e.g., when filters or slicers are changed).

2. Add a Dummy Toggle for Refresh: Create a dummy table for a toggle button or slicer.

    

   • Go to Enter Data in Power BI.

   • Create a table called RefreshToggle with a single column and two rows:

     • Refresh
       On
       Off

3. Use the Toggle to Trigger Recalculation: Add the Refresh column from the RefreshToggle table as a slicer or a button on your report. When the user toggles the slicer (e.g., switches between "On" and "Off"), it forces the report visuals to refresh and recompute the RandomValue measure.
4. Display the Dynamic Value: Use the RandomValue measure in a card or visual to display dynamic responses. The value will update whenever the slicer state is toggled.

Option: Power Automate Button for Refresh
If you need a broader refresh (e.g., refreshing datasets or visuals), you can integrate Power Automate with a Power BI button:

1. Add a Power Automate visual from the Power BI visuals pane.
2. Create a Power Automate flow triggered by the button that refreshes the dataset or triggers the desired action.

Why HTML or JavaScript Won't Work:
Power BI visuals operate in a sandboxed environment that doesn't allow custom HTML or JavaScript for security and compatibility reasons. This is why embedding code like window.location.reload() will not work.

Using the randomization technique with slicers or Power Automate provides a secure and Power BI-native approach to achieve your goal.

I hope the provided solution works for you

If I have resolved your question, please consider marking my post as a solution. Thank you!
A kudos is always appreciated—it helps acknowledge the effort and keeps the community thriving.