Hi...when we click on the drop down in the filters pane ,for example lets take a country column as shown in the video what are the numbers coming next to the country name .
I did not know 3 the three first tips, which means a 60% use. In my reports and panels my e-mail will appear and this change will be immediate. Thanks for this video.
You did surprised me with all 5. My organization use Tableau as a official BI tool, but I like watching your chanel since there are many things that I can apply in other tool as well. Also in Excel. I like the second trick the best, I could use it right away on Monday.😃
Hi Tamir!! 😃, to suggest topics, the best way for now is: curbal.com/contact. I have explored other options but haven’t found anything good yet. Any suggestions?? Curbalers! That was great!! /Ruth
@@CurbalEN I've used asterisk & Wingdings and it worked in PBI Desktop, but after publishing I see asterisk, not an envelope. Do you know why? PS. I love your tips :)
I have very basic requriment Data Source=CSV File on orginsational portal. This file gets refreshed by other team in organistions I have no controle on this. Problem= Every refresh overwrites previouse week counts. My PowerQuery= After applying certian filters I need to count number rows on weekly basis and display in PowerBI report(I need to append rows on weekly basis).It is like taking snapshot of the source and appending data over the time. Option tried A)I have tried Incremental refresh because there is meaniful date column in source it is making hard. I have added today's date B)Append!!I have also tried Append query option but everyweek it overwrites previouse week. C) Create history table in PowerBI and insert row everyweek. Using power Query Table.InsertRows(from live refresh to exisiting table in PowerBI) This is not poissble either using PowerQuery you cant insert rows from another table. I have been working as BI for last 10 years. I know this is very basic requirment in SQL Server insert into statment will do this easily for me. But I dont know how to achive this PowerBI.
Hi Ruth, 2nd tip regarding email link is not working for me. I am following it word by word. But after clicking the mail icon, my mailbox with the email inside is not opening. Only a blank tab opens. Please help me. Thank you.
Hello, I know this vide was posted in 2018 but here is a TIP I learned: 2:50 If you click on the top Name (not the box, but the name) hold shift and click on the last Name it check all items :)
Hi, mailto seems to have problem with Chrome. is there a way to make the Mailto link to open outlook without making the customer worry about which browser he uses?
In the filtering tip, If you select "Contains" and type "S" it will find all countries and regions that contain an "S" anywhere in the name. What is the point of using a wildcard here?
I am taking with me the possibility to create the mail in a textbox so the users can start opening the tickets before they start bugging me with unmeasured emails.
I love TH-cam and it is only because of the content people like you provide. Thanks a ton!
I did not know any and I know these Top 5 tips and especially the last ONE was EPIC. I was struggling to do it earlier today and your video HELPED :)
5 years later and you just made my job so much easier. Thanks!
Really good, Curbal! Didn't know 2 of them! Cheers!
Yey!!! Thanks Karine :)
/Ruth
You got me on all 5..... Thank you so much for enhancing our skills
Thanks for sharing and more tips to come :)
/Ruth
This were a really good tips. very good Ruth. Thanks
Hi Rafael thank you!! :)))
/Ruth
Hi...when we click on the drop down in the filters pane ,for example lets take a country column as shown in the video what are the numbers coming next to the country name .
Where in the video I show this?
/Ruth
Absolutely mind blowing, Ruth. Thank you for sharing. Have just got into Power BI and loving it.
Oh, be careful! Power BI is additive! ;)
/Ruth
I did not know 3 the three first tips, which means a 60% use. In my reports and panels my e-mail will appear and this change will be immediate. Thanks for this video.
That is a fast turnover from insight to action!
:)
/Ruth
What can I say ? all the 5 were NEW (not know) for me. So Thank you very mutch. I will add all these in my Tips and Tricks list.
So you knew all 5? Mmmmm I will have to do it better next time! ;)
/Ruth
Sorry Ruth NEW not know. my mistake i will update the original comment
And my favorite is the email one
Oh! Got you, perfect then!
Have a great weekend!
/Ruth
Thank you so much. It really surprises us.
Power BI is like a box of chocolates 🍫
/Ruth
Five simple but great surprises
:) simple things are the most Beautiful right?
/Ruth
Thanks Ruth!! As always very useful tips!!!
You welcome Rolando! Any favorite?
/Ruth
they are all my favorites!! :)
😂 You are right, why do we have to choose?
/Ruth
Love these videos! More please :) I knew 4 &5 but not1-3. I like 2 the most, the mailto link!
Then I did good for you :D
I will keep doing them then, they are a lot of fun to do also!
/Ruth
the mailto opens a new browser page as well as outlook.. is that normal?
Not that i know...
/Ruth
thank you so much!!! Very useful information :))))
Dear Ruth, you actually taught me 5(!) new things :-)))
Thank you,
Tamir
Yey!!! Fantastic!! I love it when my videos are useful!!
/Ruth
I knew only the last two. Thanks a lot. The fifth one is Awesome!
Yes, my favorite too with n2 :)
/Ruth
Thanks Ruth! 3 of 5 for me.
Thanks Alina! #1 to #3?
/Ruth
1,2 &4. Very helpful as usual!
Almost!! And thanks for the feedback 🤗
/Ruth
That's great, Curbal!
Hugs from a brazilian fan.
Thanks Jonas ! Hugs back :)
/Ruth
Cool - 1 & 3 are new to me. Thanks!
Oh great! More tips to come, stay tuned! :)
/Ruth
Didn’t know all 5 thanks!
Yey!!! Great :))) Hope you enjoyed them!
/Rutj
Thanks Curbal, i didnt know 2 of them :)
Mmmm let me guess: 1 and 2?
/Ruth
Close.. 2 & 3 :)
😂😂 Not bad!!
/Ruth
Awesome 5!!!! Thanks
You welcome Srin!
/Ruth
That’s awesome...thanks for the tips... love to know more tips ... they are really helpful
There are more! Here are some:
m.th-cam.com/video/iaLunDoptvs/w-d-xo.html
m.th-cam.com/video/EvQRh4Q8jGA/w-d-xo.html
/Ruth
Thanks Ruth. Yep, that's 5 new things I picked up. Cheers
Wonderful! Which one is your favorite?
/Ruth
They're all super tips but you had me at #5 control-click filters! That was best for me. Thanks
You did surprised me with all 5. My organization use Tableau as a official BI tool, but I like watching your chanel since there are many things that I can apply in other tool as well. Also in Excel.
I like the second trick the best, I could use it right away on Monday.😃
Cool! And clever approach:)
Super useful!!
Perfect!
/Ruth
Great tips :)
Wow. Thank you Ruth for this useful video. Keep up the good work.
You welcome!
/Ruth
Great tricks!! Thanks Ruth 😊
Glad you liked them! :)
/Ruth
Hi Ruth, how can I send you a question or suggest a topic? Is there a forum for curbalers?
Hi Tamir!! 😃, to suggest topics, the best way for now is: curbal.com/contact.
I have explored other options but haven’t found anything good yet. Any suggestions??
Curbalers! That was great!!
/Ruth
Thanks so much... all your videos are so useful :-)
Thanks!
Very Good! Tks
You welcome Salvatore!
/Ruth
Hi, i Really like tip #2 and 5, I am going to use #2 right now.
Impresive quick action! Quickest ever to be exact! :)
My favorites too by the way!
/Ruth
Thanks Ruth, This is a great video..
Can you do a video about installing the on premises data gate way in Power bi services ?
Absolutely, but in the meantime, here is a really nice guide:
www.mssqltips.com/sqlservertip/4232/how-to-use-the-power-bi-enterprise-gateway/
/Ruth
Asterisk & Wingdings... Really Cool!
Thanks a lot Ruth!
Josep.
Who knew right?
Happy Friday!!!
/Ruth
@@CurbalEN I've used asterisk & Wingdings and it worked in PBI Desktop, but after publishing I see asterisk, not an envelope. Do you know why? PS. I love your tips :)
@@annaj4504 weird, it should work on the server too...
I have very basic requriment
Data Source=CSV File on orginsational portal. This file gets refreshed by other team in organistions I have no controle on this.
Problem= Every refresh overwrites previouse week counts.
My PowerQuery= After applying certian filters I need to count number rows on weekly basis and display in PowerBI report(I need to append rows on weekly basis).It is like taking snapshot of the source and appending data over the time.
Option tried
A)I have tried Incremental refresh because there is meaniful date column in source it is making hard. I have added today's date
B)Append!!I have also tried Append query option but everyweek it overwrites previouse week.
C) Create history table in PowerBI and insert row everyweek.
Using power Query Table.InsertRows(from live refresh to exisiting table in PowerBI) This is not poissble either using PowerQuery you cant insert rows from another table.
I have been working as BI for last 10 years. I know this is very basic requirment in SQL Server insert into statment will do this easily for me. But I dont know how to achive this PowerBI.
yah , I loved the last one
Mee too :)))
/Ruth
Thanks
Thanks all of them.
😊
/Ruth
Short and sweet :)
😂 Did I say that again? 😂😂
/Ruth
Yup, you completely manage to surprise me. Got to know 4 new tips.
Also to select multiple tables to load, you can double click on each table.
Thanks for sharing :)
/Ruth
Hi Ruth,
2nd tip regarding email link is not working for me. I am following it word by word. But after clicking the mail icon, my mailbox with the email inside is not opening. Only a blank tab opens. Please help me.
Thank you.
Very good! Only email tip!
Phew! At least I got one :)
/Ruth
Hello, I know this vide was posted in 2018 but here is a TIP I learned:
2:50 If you click on the top Name (not the box, but the name) hold shift and click on the last Name it check all items :)
Awesome!
Hi I have a requirement in my project to send a mail to one DL( Distribution list) as soon as i click on button. How does it be configured
Please post in the power Bi community and give as many details as possible to get proper help.
/Ruth
Super trucos!!!!, Gracias Ruth!!!
Todo un placer Norberto :)
/Ruth
Hi, mailto seems to have problem with Chrome. is there a way to make the Mailto link to open outlook without making the customer worry about which browser he uses?
Thank you! This was useful 😊
Wonderful!!
/Ruth
In the filtering tip, If you select "Contains" and type "S" it will find all countries and regions that contain an "S" anywhere in the name. What is the point of using a wildcard here?
I am taking with me the possibility to create the mail in a textbox so the users can start opening the tickets before they start bugging me with unmeasured emails.
I knew all of ‘em 🙂
Whaaaaa??!
Well done!! :D
/Ruth
A puntito de los 10.000! dónde es la fiesta?
😂😂😂 habrá que hacerla virtual !! :)
/Ruth
Is it obligatory to add an asterisk before alphabet for filtering I tried without even it's working well
Asterisk is a wildcard meaning “contains”. You don’t need to use it if you don’t want to!
/Ruth
All of them 😎
Congrats!!🎉
/Ruth
Esta vez, si me los sabía todos, pero de todos modos muchas gracias
Todos,todos? Vaya!!! A ver si me aplico para el siguiente ;)
/Ruth
Si esta vez los conocía todos, de hecho los uso frecuentemente
Para la próxima!! :)
/Ruth
Supper
Did I manage to surprise you with any of the tips?
/Ruth
yes, contact mail and control click.
1 mail tips
I think Charles won the tip race today!
/Ruth
Adding a link with your email
That is by far the most liked at the moment :)
Chass is the winner!
Happy Friday John!
/Ruth