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'
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!!!!!
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
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.
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)
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?
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?
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?
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?
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
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.....
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
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
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 :)
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
CAUTION! Over valuable content 😀
Loooooove smart alerts!!
Ruth - so good! Thank you for taking the time to create these videos.
😊
You are killing it with these PBI/Power Automate videos, thank you very much!
🤣 Once I started I couldnt stop!!
@@CurbalEN please keep going!! This is amazing content and we didnt know we needed them until now!
I am making you work hard! 😂
@@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!!
😂😂 Fair point!!
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.
Fantastic and well done!! 👏👏
Hi Ruth, this is amazing series! Thank you!
Loved to make them :)
This is very good Ruth. Thank you so much
My pleasure 😇, i love it :)
Great video, if there is a way to align column with values to the right side?
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'
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!!!!!
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…
@@CurbalEN ok cool. I will give that a try. Thanks!
Hi all, I need your help how to bold the text by using dax, is it possible on power bi
That's really cool, thank's
It is!!
awesome video can't wait to apply this in my workplace
Yey!! Go, go, go 🚀🚀
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
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.
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)
Durante un largo tiempo he esperado esta funcionalidad, está muy bien explicado y tus videos son muy buenos..!!, muchas gracias.
Yo también!! (Esperando;)
Fantastic video, Thanks for sharing
Wish I could see all the alerts you all are going to build 😆
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?
Amazing!! I love you!!!!
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?
Post the details on the powerautomate community. They should be able to help you!
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?
Sure! I don’t see why not :)
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?
I don’t know, check with the power automate community
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
6:43 Ok. This is answering my questions for the other videos , and it's giving me more ideas : )
Wonderful!! 🎉🎉
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.....
Interesting thoughts..
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
You are probably hitting the api limit and need to loop the downloads. Video coming soon!!
@@CurbalEN thanks please create that
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
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 :)
Thanks!
Super thanks!
Bravo!!!!!
🎉🎉
long time... this is what i need it, lets see if i can figure it out...🙂
You will :)
How to Export the PowerBI Data fully using power automate
Mind blowing - gracias
Un placer John :)
great video - btw, I think you are using the wrong format string for the date. mm show the minutes, MM should show the month.
Thanks :)
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
Cool, thanks for sharing!
Something like this should do it;
formatNumber(item()@, 'C3', 'en-US')
Great video - really interesting. Quick question - what happens when it's Jan 2023, will the prev month variable become Dec 2023 not Dec 2022??
😂 somebody else pointed that out, you can fix that in DAX
Hi request you to pls make a video how to extract tables from mail using power automate
interesting!!
Really cool 😎
Good
I would say, fabulous!! 😁😁
Alt for lækkert, tak :)
Varsågoda och glad midsommar!!
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
You can trigger it from the desktop, but the data needs to be in the cloud
Maravilhaaaaaaaaaaaaaaaa
Obrigada!!