Trigger a Dataset / Dataflow Refresh using Power Automate / Beginners Guide to Power BI in 2021

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

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

50% 1

In this video I'm going to show you how to check when a refresh is complete AND how to trigger a refresh using Power Automate.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 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

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

12 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@antoniogarrido3058 2 года назад

Thanks for sharing! Really usefull and practical solution. I'll try to implement it, for sure!! 👍

@SolutionsAbroad 2 года назад

Great to hear that, good luck!

@Tattysnuc Год назад

great tip. thank you for sharing

@oladman9058 Год назад

This video is a wow!

@virgie1728 2 года назад

Your vlog contents are great, i just wished it could be more "zoomed-in" though so we could appreciate it more🤗

@SolutionsAbroad 2 года назад

Hi I'll keep that in mind, thanks for the feedback!

@karthikeyank3225 2 года назад

Hi Frenan, can we implement power automate in Oracle database instead of a SharePoint folder? Since our data for power bi lies in Oracle database.

@pluralcloud1756 2 года назад

Thank you-- can this be run from a Service Account?

@SolutionsAbroad 2 года назад

Hi there, yes of course! As long as the service account has access to the SharePoint site and a Power BI license

@nathanandmycountries 5 месяцев назад

Hi frenan, how to do the flow if we have multiple four dataflow and one dataset ? Thanks

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

When the new file came in share point then how it will be fit in model in report?

@AntoineTerrade 2 года назад

Hi great content thanks. Is there any way to know the error when the dataflow fail, I manage monitoring my dataflow but I only know the status (success/failed) but not the error message :(

@SolutionsAbroad 2 года назад

Hi Antoine! I'm pretty sure a pre-made template is available for you to use as a trigger if your dataflow is successful or not. I covered it in an old video I remember, where I refresh the Power BI dataset when the dataflow refresh completes. Anyway, here's more info on the flow: docs.microsoft.com/en-us/power-query/dataflows/dataflow-power-automate-connector-templates

@AntoineTerrade 2 года назад

@@SolutionsAbroad yes I used this steps to create my dataflow monitoring but I don't have the error message when the Dataflow failed :/

@user-dv7hi9fw9y 3 месяца назад

hey master , I got some problems in my project pfe and I need your help if you don't mind please

@gitanjalimajumder7346 Год назад

Can you please do the same operation for sql instead of SharePoint

@pritamkotekar1816 2 года назад

nice video, How to configure for VIEWS which is available in aws athena. When VIEWS refreshed in data source then automatically data set should refreshed. How to configure power automate for this ?

@SolutionsAbroad 2 года назад

Hi there, not sure about AWS, but if its an online source then it should be able to schedule its refresh

@pank-7423 2 года назад

When we say when a dataflow refresh completes, does it mean only succeeded? Or can it also mean failed? Also how can we run multiple dataflows one after other? Do we need to keep the step of "when a dataflow refresh completes" after every dataflow refresh step??

@SolutionsAbroad 2 года назад

Hey there, great questions! to answer them individually: - the dataflow trigger means when it succeeds, not when it fails - I've only ever worked with one trigger and a string of actions within one dataflow, I always created a new automated flow with the "when a dataflow refresh completes" trigger

@lzaconeta 2 года назад

hello fernan For the update to be successful, is a gateway necessary? Because in both flows power automate finishes successfully, but when I return to Power BI in the dataset it shows me an error about credentials. Data source error: The scheduled upgrade appears to have failed because at least one data source is missing credentials. To start the update again, go to the settings page for this dataset and specify the credentials for all data sources. I have a student account, but I activate the pro option for 60 days, could that be the problem?

@SolutionsAbroad 2 года назад

Hi Luis, this should not require Pro or Gateways to work, as long as all your data sources are stored online, these should work as expected. Check your data source credentials settings on Power BI Service, sometimes this needs reauthenticating

@gandharsakpal9527 Год назад

can we just automatically refresh a certain data model in power bi ??

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

How many refreshes can possible for Pro account with power automate. As we know 8 times is refresh limit for Pro account when we setup in power bi service. What is share point list updates more than 8 times will it refresh beyond that??

@boorugusaikiran973 2 года назад

What can we do if we have data from SQL database?

@SR-ho8pf 11 месяцев назад

I want to trigger another flow after the data set have been refreshed I don't know when my power bi file get completely refresh , after the file get refrehed the flow should start

@NewITGuy9 Год назад

Can we refresh dataset by automate with pro account

@bilelhammi8286 Год назад

How to refresh many dataSet (not one many dataSet) in workspace

@EvilGost7878 Год назад

Interesting video. But it does not ensure that your dataset will be refresh at 7:30. It just ensure your dataset will start to refresh. My concern is that there is no native feature to trigger when a dataset refresh is over.

@henrydominguezsilva5266 Год назад

Did you find any solution for this? I have the same problem. I need to ensure that the dataset has been refreshed and trigger the following steps start. It looks like this current action just ensures that the data will start to refresh.

@ammanscorpion03 Год назад

Hii, how to create this lineage dataflow, please guide

@GreyhoundTrading Год назад

I'm trying something similar but I have been getting a 400 error - Bad Request. Did you have some similar issue?

@SolutionsAbroad Год назад

Hello, not with this solution, which part of the process does this error occur? most common issue usually is authentication so check that your credentials are up to date

@GreyhoundTrading Год назад

@@SolutionsAbroad I will answer on your linkedin. ok?

@babu8090 Год назад

Can we get a notification if the dataset failed to refresh

@anapaola8373 Год назад

I don't see my dataset inside "my workspace" :(

@singamramireddy122 2 года назад

Nc explain give me ur num i want training or ur videos or else please do a video how to automate instead of share point use hive or denodo please do that video