Smart Alerts are finally here!!! 🎉

I have been wanting to do this for the longest time and now it is possible. Introducing.... Smart alerts in Power BI!!!
Links of resources mentioned in the video:
Export data with Power automate filters: • Filter Power BI export...
Styling tables: www.w3schools....
Create Power BI links: docs.microsoft...
If you want to learn more about exporting Power Bi data using Power Automate, check the entire playlist:
• Export data from Power BI
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
************
MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10
Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@kadirkkkk]

CAUTION! Over valuable content 😀

[@CurbalEN]

Loooooove smart alerts!!

[@rauljimenez5485]

You are killing it with these PBI/Power Automate videos, thank you very much!

[@CurbalEN]

🤣 Once I started I couldnt stop!!

[@dcpowered]

@@CurbalEN please keep going!! This is amazing content and we didnt know we needed them until now!

[@CurbalEN]

I am making you work hard! 😂

[@rauljimenez5485]

@@CurbalEN I would say (very nerdly) that, since you have shown me how to automate so many things, I am working LESS hard 😅 THANK YOU!!

[@CurbalEN]

😂😂 Fair point!!

[@charliemmadad]

Ruth - so good! Thank you for taking the time to create these videos.

[@CurbalEN]

😊

[@chrisgreg1]

Thank you for this video! It's really useful! I couldn't understand why the months were showing up as 00 when I tried it myself. Formatting for the months needs to be caps : 'yyyy-MM-dd'

[@fernandamello837]

This is A-M-A-Z-I-N-G! I love it ! I made the same idea on my job and they absolutely love this idea.

[@CurbalEN]

Fantastic and well done!! 👏👏

[@elhassanaitelhadj8796]

That's really cool, thank's

[@CurbalEN]

It is!!

[@barp21]

Great video, if there is a way to align column with values to the right side?

[@PedroCabraldaCamara]

This is very good Ruth. Thank you so much

[@CurbalEN]

My pleasure 😇, i love it :)

[@JoelNove]

WOW!!! You must be the only one who was fully able to show how to do this in YT. Bravo 👏. One request…How do we filter on email dedicated to that specific record and email INDIVIDUALLY to that email with their table record(Reminder email to fill out data). Thanks!!!!!

[@CurbalEN]

You can use the email property when triggering the flow using the power bi button. That way flow knows who the person is triggering it…I think…

[@JoelNove]

@@CurbalEN ok cool. I will give that a try. Thanks!

Hi Ruth, this is amazing series! Thank you!

[@CurbalEN]

Loved to make them :)

[@nmthd]

Durante un largo tiempo he esperado esta funcionalidad, está muy bien explicado y tus videos son muy buenos..!!, muchas gracias.

[@CurbalEN]

Yo también!! (Esperando;)

[@dicky4780]

awesome video can't wait to apply this in my workplace

[@CurbalEN]

Yey!! Go, go, go 🚀🚀

[@midhunkumar1499]

Hi all, I need your help how to bold the text by using dax, is it possible on power bi

[@barp21]

The second question is how to replace qualified column names with user-defined names? For example, from BI I'm getting dim_Material[Material] and I would like to have "Material" instead

[@balaji_906]

Fantastic video, Thanks for sharing

[@CurbalEN]

Wish I could see all the alerts you all are going to build 😆

[@selectforsql9483]

Thanks!

[@CurbalEN]

Super thanks!

[@professionalboxingindia160]

Thanks for the video however can we have an email alert if we see a discrepancy of + or - 30% in the value of a metric once there is a data refresh done. Since we get data with as on date we cannot compare it with previous week since that also tends to change.

[@김차수-k2u]

Amazing!! I love you!!!!

[@elrevesyelderecho]

6:43 Ok. This is answering my questions for the other videos , and it's giving me more ideas : )

[@CurbalEN]

Wonderful!! 🎉🎉

[@tonytarragona6655]

long time... this is what i need it, lets see if i can figure it out...🙂

[@CurbalEN]

You will :)

[@TazmanianFlo]

great video - btw, I think you are using the wrong format string for the date. mm show the minutes, MM should show the month.

[@CurbalEN]

Thanks :)

[@JohnOttoKnoke]

Mind blowing - gracias

[@CurbalEN]

Un placer John :)

[@mszakalinski]

That's brilliant! Would it be possible to add conditional step there? Like if query result = 1 then next query and email if query result = 0 then finish flow?

[@CurbalEN]

Sure! I don’t see why not :)

[@МаргаритаГацук]

Thank you for another amazing video, really useful. I was wondering is there the possibility to extract the emails for such notification from PowerBi dataset also? Meaning that notifications should be sent to dynamically selected users from power bi data (have emails in report). For now I have only managed to make the notifications semi-automatically - still need to push button in the dashboard to trigger notifications sending. But I cant find the possibility to connect preselected PowerBi data to recurring workflow

[@CurbalEN]

I have Some videos on how to trigger the notification automatically, check them out. Regarding the emails , it might be possible? If you post in the power Automate community I am sure someone will be able to help :)

[@jackstrudley1039]

Great video as always. I'm wondering if maybe the table could be put into a paginated view to almost recreate paginated reports for users that have Pro licenses only. Also wondering if a row limit might impact that.....

[@CurbalEN]

Interesting thoughts..

[@ranjitht.r5836]

How to Export the PowerBI Data fully using power automate

[@willyms]

Bravo!!!!!

[@CurbalEN]

🎉🎉

[@modi_cl]

Awesome video, Just created a daily report with due date of payments in a small company I'm currently working!!!. I only have a problem with the currency format, It shows it as an INT number instead of currency, any tips on how to fix that? Gracias Ruth!!, saludos desde Chile

[@CurbalEN]

Cool, thanks for sharing! Something like this should do it; formatNumber(item()@, 'C3', 'en-US')

[@joseluischamblas4192]

Muchas gracias Ruth! tengo una duda hice el siguiente formateo de fecha: formatDateTime(item()?['TABLA[Fecha de creación]'],'yyyy-mm-dd') y me esta generando ceros en el mes, tengo algún error en la formula? (el año y día lo genera sin problemas)

[@analyticsadda6080]

Hi request you to pls make a video how to extract tables from mail using power automate

[@jamesmoran3573]

Hi, I am facing issues with reports on powerbi service, no one provided proper solution. How to clear saved credentials in BI service. My data sets are connected using OData feed to CRM tool. Demand refresh or schedule refresh fails with error “failed to update credentials, timeout error” Could you please do a video on refresh fails

[@elrevesyelderecho]

6:44 But in this case, you are pasting the table exported to the email...if I want to attached to the email instead? Do I have to save the file first and the do the "send email" step, right?

[@bonsai_mad8139]

Great video - really interesting. Quick question - what happens when it's Jan 2023, will the prev month variable become Dec 2023 not Dec 2022??

[@CurbalEN]

😂 somebody else pointed that out, you can fix that in DAX

[@BarbaraCarolineFerreiradaSilva]

Hii, I'm still finding some problems in formatting my html table. I create a 'Compose' to format my table, but when I sent a email, my table is still no getting the format from the 'compose' style. Do you know why this still could be happining?

[@CurbalEN]

Post the details on the powerautomate community. They should be able to help you!

[@mineeeeful]

Hii! Isit possible to have a dynamic folder path when creating file in sharepoint/OneDrive? Let’s say I’m gonna create a new folder every month (naming it the latest month). Can I make my flow with a dynamic folder path to choose the folder to save in based on the existing month?

[@CurbalEN]

I don’t know, check with the power automate community

[@sharavananp5570]

interesting!!

[@CurbalEN]

Really cool 😎

[@noompp2061]

Good

[@CurbalEN]

I would say, fabulous!! 😁😁

[@khan.naved1]

Hi Curbal , can you suggest how to extract all data and sending it using csv? i tried using this with the combination "create csv" however it is showing 45000 rows of data only

[@CurbalEN]

You are probably hitting the api limit and need to loop the downloads. Video coming soon!!

[@khan.naved1]

@@CurbalEN thanks please create that

[@powerbinareal]

Maravilhaaaaaaaaaaaaaaaa

[@CurbalEN]

Obrigada!!

[@Henrik.Vestergaard]

Alt for lækkert, tak :)

[@CurbalEN]

Varsågoda och glad midsommar!!

[@FTDB_KS]

Hi Curbal did we Need Power Bi Service for your Solution and is it possible to realize Data Alerting only of Power Bi Desktop base? Thank u

[@CurbalEN]

You can trigger it from the desktop, but the data needs to be in the cloud