Refresh ALL Reports with ONE BUTTON using Power Automate // Beginners Guide to Power BI in 2023

Подписаться 46 тыс.

Просмотров 13 тыс.

50% 1

In this video were going to go through how you can set up a button which can trigger multiple dataset refreshes with one click.
-
🚩 Get Demo Files here
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 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 RU-vid.
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
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 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.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 12

@MrSF0RZA Год назад

Appreciate the content- helps me come up with new ways to solve problems… I always share with my team. Cheers pal

@POng-lq6yj Год назад

Thank you, Fernan. You are one of my inspirations! ❤

@benndii Год назад

Really nice! I use new files in my sharepoint source folder as the trigger for data refreshing, which works really fine and is easy to set up.

@krayan11 Год назад

Thank you so much. I was looking for a way to auto refresh my power bi report without clicking anything. I would really appreciate if you could do a video about the second thing that you mentioned at the end of the video. Great work and thank you.

@shrikanthpremklumar7492 Год назад

Thank you for the video .. I have couple of questions ,? 1. At what situation we can use button and trigger Power BI dataset refresh, the reason is - if I accidentally click a button twice or thrice , will there be multiple Refreshes for the same report ? 2. Will I be able to schedule more than 8 times using Power Automate for the datasets that resides in Non- Premium capacity. 3. Does this Power Automate Refreshes gets recorded in Power BI refresh history? 4. In Power BI premium P1 capacity - there are 40 parallel dataset Refreshes allowed, is this condition applicable if we perform refresh using Power Automate? 5. Will I be notified of Power BI refresh failures ? 6. As Microsoft have recently introduced " Cancel refresh feature " ..in that case how I do cancel all Refreshes using Power Automate ? Is it possible ?

@utubebellamkonda Месяц назад

Adding multiple refresh dataset actions is not optimal if you have more than handful datasets. Can we get items from sharepoint list and loop through?

@chjpiu 10 месяцев назад

Thanks a lot. Could you please ask what I can do if my dataset is too big and cannot be published on the PBI service? How can I refresh w/o publishing

@amosjonsen3131 Год назад

How can you enable API token authentication on a workspace. I have been able to do it on Power BI desktop but the workspace doesn’t seem to have that capability. Can you please help me?

@abhaygupte Год назад

I have 12 datasets which I need to refresh every end of business day. The issue is each refresh of the SQL DB refresh to Azure Environment, the Server Name, Database Name, User and Password is changing and I need to pass this info to the PBI Connection manually. Is there a way to Update all these 4 through a Parameter or CSV or Excel Sheet before I create and trigger the method suggested in this video.

@kavita8390 3 месяца назад

Nice, but this refreshes the report on power bi service but not on desktop. How can we refresh the desktop report as well without manually refreshing it?

@g2delena 3 месяца назад

Yes, this is a similar task that I am looking to do. How do we automatically refresh to the source data or files w/out manually refreshing with the desktop.