How to add a REFRESH DATA BUTTON in your Power BI Reports using Power Automate // Beginners Guide

Get Demo Files here

In this video we're going to go through how you can add a refresh button in your Power BI reports using the new Power Automate visual.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[allardbon]

Fernan, you made my day! This is extremely handy! This makes all my cumbersome direct-query-attempts useless!

[aneternall]

I also learned it's important to add "All Users" the the "Run only users" section if you want others to use the button. However I was experiencing up to a 6 hour delay for a refresh to occur, so I gave up on the button and just have it refreshing automatically a few times througout the day.

[jessykms]

Thank you so much! It helps me a lot because the users wanted to refresh data. I tried it and it is working very good!! Thanks!!!😀

[amirmollaei]

Hi,
Can we add such button in the Report Server?
Thanks.

[JeroenNiebuur]

Does this bypass the 8 time refresh limit of pro?

[jesuspj]

Good video and very useful @Solution Abroad, however it doens't look working as expect in power bi embedded.

[ConnorDoherty-ux]

Is it possible to do this and the button will refresh only 1 table? Would be great as would be much faster and display the change immediately for the modified info only

[last_minute_film]

Hello - Great demo. Can you show how to do this with a database

[andresadan]

Hi!
It looks good but when im trying to set the "DataFlow" update, it says "Connection Locked for Data Loss prevention" and doesn´t allow to sign in and create this step in Power Automate. Is this a new security block by PBI?

[LuiissR]

Thank you so much for this, I had been looking for this for a while.
However now I'm facing a different issue: within PBI desktop the button displays correctly, same in the Power BI service and can be used to trigger the flow successfully, but does not work in the embedded web page.
Have you heard anything about this and have any clue how to solve it?

[legendgod]

Can I make a button to refresh dataset as well as refresh the page? Everytime I have to refresh the page to see the report update.

[JohannFritz]

How do you add an action to the button to refresh the report visuals as well?

[moshearama]

there is something similar withpower bi desktop ?

[elsagirma]

Hi created the click button works fine the question is the ms flow stored under my personal environment instead of the project environment, is there any way to use flow from same environment where the data flow stored ?

[quackquack]

I'm using the refresh button, when i publish to the web it's visible in power bi service, but it's not showing in the sharepoint site.

[mdsourav]

It does not work on public sharing. right?

[smritishrivastava]

Hi i am unable to use this button even after following the mentioned steps

[aliazwer]

Hi Fernan, do you need Gateway to be configured to make this work ?

[divyarajan]

Hello I am working with a combination of SQL server DB and Cosmos DB for Power BI reporting. Wanted to know if power automate can help me with near real time reports

[KomailButt]

refresh button is not working when I use this button through power bi report present on sharepoint page.