Ruth, I have enjoyed your content, and the recent interactivity at the end of the videos was nice. Perhaps one thing you could do is similar to what you were doing with charts before - show a chart (either current or past) and in the comments we can talk about was was good or bad about the way the data was presented. I feel that I always learn a lot about visualization from these types of posts/videos, and the more people commenting the better
Great tips, Ruth! As many others have stated, I also had no idea about the cancel refresh option. This will save so much time! And thanks for the shout! Very much appreciated 😊
Great tips as always.. I would really like to hear your advice u would throw to someone who like to climb the ladder of power BI in fast pace possible.. Meaning moving from basic to pro..
Hi Ruth, Whatever i have learned in Power BI till date is because of your videos and the tips and tricks which you have provided. Your videos are very informative and are used in most of the solutions which we have been working on. It really came as a shocker to me when I heard that you are going to stop the Power BI exam questions. Do not know why, but I am sure you would have evaluated before making such a decision. My suggestion of what we can have at the end of the video is Option 1 :Something on Visualizations. Perhaps some best practices or how can we make the visualization better. Some of us are unaware of the visualization tips and tricks. Option 2: Something related to real case studies you are working on. A small case study and what can be the possible solutions for this. For example, you share a dataset and we try to find the solution as there are multiple answers to a solution in Power BI. Can be done via Power Query, using different functions in DAX. Just random ideas. hope it helps.
I had to, I am sorry, otherwise both you and I would have gotten into trouble :( As for what to do next, thanks for the ideas! I will see what I can do that do not demand a lot of preparation! /Ruth
Great work Ruth! Thanks for all your effort for us! Another tip, not quite the same is that if you refresh your data and you want to revert back, you can always close Power Query without applying and then close the file. You should sit the exam!!
Great Video Ruth,and Sad for the dicountinutity of Exam suppourt you really did great showing the suppourt and idea of challenge really smart. However,apprectiate your decision. Idea 1- suggest you can receive Power BI report Samples from community and discuss each video the good and bad of the received reports.also you can make a categorization for this so you can discuss a series of videos reports related to sales,then supply chain,then IT , etc. idea 2- Explore new Custom Visual every Video and examin Pros/Cons for each.
Hi mam, Would you able to provide which Certification would be better to take with Tableau for MS Business Intelligence. I have actually took training with MSBI included Power BI & PL/SQL(encoded with Tools SSIS, SSAS & SSRS). Would you be able to help me out. Looking forward for valuable suggestion.
6:30 thanks for you effort and the set of questions provided. It was a good discussion and help me a lot during my preparation time. Those 3 weekly help me a lot to study and pass the exam. Honestly, with your knowledge you will pass with a good rate. Take the exam any time, you don't need to study more 😉 la molas! One idea, what about a sort chart at the end of the video about one subject? People that what to continue studying with through this way can a subject or a question and you provide feedback. Or just maybe a final two minutes where you chat about something that you learnd recently related to the exam. Anyway, gracias por tu apoyo y estímulo. Creo que tiene muchas ideas que puedes explotar y generar más contenido. Besos.
Hi Ruth, I think your question is very interesting. How about ending each VDOs with some tips, tricks on how to display grid/ chart/ graph in a more "story telling" way. Like what aspect we should do to improve visuals of charts ( I have seen many many reports which are badly displayed, cannot understand what message the author want us to get).
I just have one doubt in power query.. I need concatenate outputs of two separate if statements in power query... When I was trying to contact using ambersent operatior it's showing syntax error
About the free entry form in slicers, you can also click on the 3-dot menu of that slicer, then select "search" (1st option). It will enable a permanent search field.
Oh ! It’s unfortunate that we need to stop the Power BI exam Tips at end of the video. That was really cool ! Going to miss that ! BTW Cancel Refresh is nice tip 👍🏾
Oh Ruth.. how mean is that? Why can't you continue.. sounds very big brother to me. The questions were very interesting and I for one learned a lot!. How about some dax refreshers.. some easy, some not so easy? And also some power query stuff.. Just today, I wanted to combine functions and wasn't sure how to go about it. and it took me a while to find the answer... but of course, you would have known that in a second!
They should also introduce cancelling for Working on it screen in the Desktop :) in case the user changes its mind . challenges to do the same in dax but in 10 different ways would be cool also from understanding performance optimization perspective
Hi Ruth, such a great video, really appreciate your efforts, I came out with two different ideas, one of them basically involves us, to interact more, here's the thing, maybe you can sort on a weekly basis a person who is gonna sent you doubts about something or 5 people, and try to help us out, sharing your videos or maybe ask for a friend to comment on our name I don't know something like that xD, I hope you get the idea, and the second one involves giving us homework, hope this helps a little bit, greetings
Thanks. Well I knew the first one! I think the disabling of filtering is quite nice. Sometimes I have to choose Edit Interactions a lot and disable filtering for the majority of vizs. Doing this is sometimes good, then I just have to actively enable filtering (rarely, if ever, x-highlighting) for specific combinations. It would be good to have this default behaviour at page-level. I agree that a viz level option of "you are not allowed to click me" would be good. ....... I thought you were going to announce your retirement from TH-cam at the end! Thankfully not.
OH, SNAP! Those *ARE* 5 tips I truly didn't know! 😮 How long have you been keeping the holy grail "Cancel Refresh" secret to yourself ?! 😉 LOL Sorry about the exam study session... I hope you didn't get in trouble... There was so much engagement with some element of competition (important because no sports now), and I was on a streak! I actually had gone through the prep books for 70-778 and 70-779 right before the announcement for transition to DA-100. I have been using your sessions to test myself to see if everything I had read have stuck (it hadn't...lol). What was the correct answer for Q29, anyway? Thank you so much for the effort you put into the 29 questions, Ruth!
I am afraid I have known that for a while, but I thought everybody knew! I would have picked answer 4 (one table in power query) Let's see if I can find something else for us to do together at the end of each video. If you have any suggestions, let me know!
oh, great, the last question was the one that broke my streak... 😞 As for the end-of-video content, maybe: 1) viewer Q&A; and/or 2) showcase of PBI Reports/Dashboards (featuring examples from the gallery or viewer submissions and discuss good/bad elements for learning and inspiration...) ... just a thought...
Hi Ruth, based on the link provided in this video, i did enrolled in the training.bielite.com/ course, however i am facing issue in connecting the server. I am unable to contact to the respective person. whom shall contact and rectify the issue ? please guide me
An end of the videos idea: Each week you give a sample .pbix (or use the same one for all) and then present a desired DAX measure(s). It could go something like: Monday: Here's the problem we want to solve through DAX Wednesday: Tips for those who may be stuck Friday: Review answers submitted by users in the comments from Monday/Wednesday This could get people out of their DAX comfort zone and would help people find new solutions to their own problems.
Hi ma'am, i dint understand 3 tips bcos i m a new learner and i have communication issue wd english u guys speak. 3 tips gone over my head😀😀 but i will appreciate if u can mail me those tips n more new things if u wish to share.
Ruth, I have enjoyed your content, and the recent interactivity at the end of the videos was nice. Perhaps one thing you could do is similar to what you were doing with charts before - show a chart (either current or past) and in the comments we can talk about was was good or bad about the way the data was presented. I feel that I always learn a lot about visualization from these types of posts/videos, and the more people commenting the better
That is a good idea and I have some charts ready. It is great if you can help me find charts to comment and publish them on the discord server for me see :)
Ruth, I have enjoyed your content, and the recent interactivity at the end of the videos was nice. Perhaps one thing you could do is similar to what you were doing with charts before - show a chart (either current or past) and in the comments we can talk about was was good or bad about the way the data was presented. I feel that I always learn a lot about visualization from these types of posts/videos, and the more people commenting the better
Cancel refresh tip is the winner. Thanks Ruth
True time saver!! 😊
/Ruth
Hi Ruth.. Very useful tips.. Thank you..
Thanks Ruth, what a lovely video you made. loving it ~
Thanks Even!
Great tips, Ruth! As many others have stated, I also had no idea about the cancel refresh option. This will save so much time! And thanks for the shout! Very much appreciated 😊
Great tips as always.. I would really like to hear your advice u would throw to someone who like to climb the ladder of power BI in fast pace possible.. Meaning moving from basic to pro..
Thanks a lot. It is very useful
Hi Ruth,
Whatever i have learned in Power BI till date is because of your videos and the tips and tricks which you have provided.
Your videos are very informative and are used in most of the solutions which we have been working on.
It really came as a shocker to me when I heard that you are going to stop the Power BI exam questions. Do not know why, but I am sure you would have evaluated before making such a decision.
My suggestion of what we can have at the end of the video is
Option 1 :Something on Visualizations. Perhaps some best practices or how can we make the visualization better. Some of us are unaware of the visualization tips and tricks.
Option 2: Something related to real case studies you are working on. A small case study and what can be the possible solutions for this. For example, you share a dataset and we try to find the solution as there are multiple answers to a solution in Power BI. Can be done via Power Query, using different functions in DAX.
Just random ideas. hope it helps.
I had to, I am sorry, otherwise both you and I would have gotten into trouble :(
As for what to do next, thanks for the ideas! I will see what I can do that do not demand a lot of preparation!
/Ruth
It was a pleasure to participate in your exam questions. Thanks for sharing the tips. The best for me was cancel refresh.
Thanks Vida!
/Ruth
Cancel refresh .. the best undo there is!
Great work Ruth! Thanks for all your effort for us!
Another tip, not quite the same is that if you refresh your data and you want to revert back, you can always close Power Query without applying and then close the file.
You should sit the exam!!
I wont pass it without studying, and I always find other prio things...maybe someday in the future!
Great Video Ruth,and Sad for the dicountinutity of Exam suppourt you really did great showing the suppourt and idea of challenge really smart. However,apprectiate your decision.
Idea 1- suggest you can receive Power BI report Samples from community and discuss each video the good and bad of the received reports.also you can make a categorization for this so you can discuss a series of videos reports related to sales,then supply chain,then IT , etc.
idea 2- Explore new Custom Visual every Video and examin Pros/Cons for each.
Hi Ahmed, thanks for the suggestion and I will look into it :)
/Ruth
Hi mam,
Would you able to provide which Certification would be better to take with Tableau for MS Business Intelligence.
I have actually took training with MSBI included Power BI & PL/SQL(encoded with Tools SSIS, SSAS & SSRS). Would you be able to help me out. Looking forward for valuable suggestion.
Gracias Ruth, muy buen video 😁
Great video! I thought the explanation about parameter order was really helpful.
Hidden in plain view ;)
/Ruth
Gracias Ruth, todos tus tips muy útiles para mí en especial el de filtro cruzado y bonito lugar al finalizar tu video, saludos.
Thanks, Great work
Wow!
This hidden Cancel Refresh item is a life saver!
Thanks Ruth for another great video
I know, well hidden in plain sight!!
/Ruth
Cancel refresh is cool! Thanks!
It definitely is!!!
/Ruth
6:30 thanks for you effort and the set of questions provided. It was a good discussion and help me a lot during my preparation time. Those 3 weekly help me a lot to study and pass the exam. Honestly, with your knowledge you will pass with a good rate. Take the exam any time, you don't need to study more 😉 la molas! One idea, what about a sort chart at the end of the video about one subject? People that what to continue studying with through this way can a subject or a question and you provide feedback. Or just maybe a final two minutes where you chat about something that you learnd recently related to the exam.
Anyway, gracias por tu apoyo y estímulo. Creo que tiene muchas ideas que puedes explotar y generar más contenido. Besos.
Thanks for the ideas and all your support!
AHHHHHHHH Cancel Refresh where have you been !!!!!! - I'm literally screaming in my head!
I know!! Hidden in plain sight!
:)
/Ruth
@@CurbalEN Totally agree :)
Great tips! Thanks, Ruth!
Thank you!!
/Ruth
Hi Ruth, I think your question is very interesting. How about ending each VDOs with some tips, tricks on how to display grid/ chart/ graph in a more "story telling" way. Like what aspect we should do to improve visuals of charts ( I have seen many many reports which are badly displayed, cannot understand what message the author want us to get).
Thanks Thăo sounds like a great idea :)
/Ruth
Thanks a lot for all your content! You are so happy when you show us different technics, that I also become happy and enthusiastic :)
😊😊
/Ruth
I just have one doubt in power query.. I need concatenate outputs of two separate if statements in power query... When I was trying to contact using ambersent operatior it's showing syntax error
About the free entry form in slicers, you can also click on the 3-dot menu of that slicer, then select "search" (1st option). It will enable a permanent search field.
I meant you cant ctrl+f to activate the search field on slicers in the desktop.
/Ruth
Oh ! It’s unfortunate that we need to stop the Power BI exam Tips at end of the video. That was really cool ! Going to miss that !
BTW Cancel Refresh is nice tip 👍🏾
I know! Hopefully I can figure out something cooler to do!!
Hi Ruth, very good tips, Thanks!!!
:)
Ah, Ctrl-f to pop-up the filter visual search box, very nice :)
Nice!
good tips!
🥳🥳
/Ruth
1:39 great!! Didn't know it
Best trick ever!
I want to learn r or python programming for power bi which is better for that please guide me
It depends on your preferences and why you want to learn. If it is for Power BI this might help you:
m.th-cam.com/video/9hLNHJ-SeW0/w-d-xo.html
/Ruth
But 'Search' field can appear in PBI Desktop slicers as well.
And to stop cross filtering, is not Format-> Edit Interactions useful?
Yes, but I cant see to get it to appear with ctrl+F.
The setting I show you will disable for all visuals at once, it is faster.
/Ruth
@@CurbalEN Sure!
Sugestion: talk about Price x Volume x Mix measures for waterfall graph or New, Lost and Existing customers in Waterfall too 😍
Thanks for the suggestion :)
/Ruth
Oh Ruth.. how mean is that? Why can't you continue.. sounds very big brother to me. The questions were very interesting and I for one learned a lot!. How about some dax refreshers.. some easy, some not so easy? And also some power query stuff.. Just today, I wanted to combine functions and wasn't sure how to go about it. and it took me a while to find the answer... but of course, you would have known that in a second!
If you guys help me to come up.with the tips, I will be more than happy to do that :)
Enjoy your day Erica!
/Ruth
Hi Erica, don't forget the third part of the Power BI exam book which is the Power BI Service!
Cheers
Ollie
Hi Ruth, I feel my PBI has slowed down significantly after updating to June release. Is this a common problem?
They should also introduce cancelling for Working on it screen in the Desktop :) in case the user changes its mind . challenges to do the same in dax but in 10 different ways would be cool also from understanding performance optimization perspective
Agreed!
/Ruth
Thanks a million, now I know how to cancel refresh :D
😊
/Ruth
Hi Ruth, such a great video, really appreciate your efforts, I came out with two different ideas, one of them basically involves us, to interact more, here's the thing, maybe you can sort on a weekly basis a person who is gonna sent you doubts about something or 5 people, and try to help us out, sharing your videos or maybe ask for a friend to comment on our name I don't know something like that xD, I hope you get the idea, and the second one involves giving us homework, hope this helps a little bit, greetings
This search box is everything that I needed. I used a plugin, but the layout is not friendly.
Thanks. Well I knew the first one! I think the disabling of filtering is quite nice. Sometimes I have to choose Edit Interactions a lot and disable filtering for the majority of vizs. Doing this is sometimes good, then I just have to actively enable filtering (rarely, if ever, x-highlighting) for specific combinations. It would be good to have this default behaviour at page-level. I agree that a viz level option of "you are not allowed to click me" would be good. ....... I thought you were going to announce your retirement from TH-cam at the end! Thankfully not.
Not yet, still have some energy left ;)
/Ruth
@@CurbalEN More than enough for the exam!!
😂😂
Can we export table from power bi to SQL server without using R or Python
You can use DAX studio also.
/Ruth
Thanks, Ruth. I love the last tips. [Heart] :P
Yey!!
/Ruth
Cancel refresh!! Love you!!!
I wondering if Guys in a Cube know about it? 🤔 A hidden gem!
They probably know!
OH, SNAP! Those *ARE* 5 tips I truly didn't know! 😮 How long have you been keeping the holy grail "Cancel Refresh" secret to yourself ?! 😉 LOL
Sorry about the exam study session... I hope you didn't get in trouble... There was so much engagement with some element of competition (important because no sports now), and I was on a streak! I actually had gone through the prep books for 70-778 and 70-779 right before the announcement for transition to DA-100. I have been using your sessions to test myself to see if everything I had read have stuck (it hadn't...lol). What was the correct answer for Q29, anyway?
Thank you so much for the effort you put into the 29 questions, Ruth!
I am afraid I have known that for a while, but I thought everybody knew!
I would have picked answer 4 (one table in power query)
Let's see if I can find something else for us to do together at the end of each video. If you have any suggestions, let me know!
oh, great, the last question was the one that broke my streak... 😞
As for the end-of-video content, maybe:
1) viewer Q&A; and/or
2) showcase of PBI Reports/Dashboards (featuring examples from the gallery or viewer submissions and discuss good/bad elements for learning and inspiration...)
... just a thought...
And please do let me know how soon i can learn this BI? If u have good idea please share with all.tnx
For sure.. inga problem!
Hi Ruth, based on the link provided in this video, i did enrolled in the training.bielite.com/ course, however i am facing issue in connecting the server. I am unable to contact to the respective person. whom shall contact and rectify the issue ? please guide me
His Twitter handle is @powerbielite
Try there!
@@CurbalEN Thank you
An end of the videos idea: Each week you give a sample .pbix (or use the same one for all) and then present a desired DAX measure(s). It could go something like:
Monday: Here's the problem we want to solve through DAX
Wednesday: Tips for those who may be stuck
Friday: Review answers submitted by users in the comments from Monday/Wednesday
This could get people out of their DAX comfort zone and would help people find new solutions to their own problems.
Uh, that would be tough for me to come up with , could work if you guys help me come up with the topics?
I have heavy confusion madam send me any tips how to understand to subject
Thanks for the Cancel Refresh tip. I have wasted so much time! :-)
Hi ma'am, i dint understand 3 tips bcos i m a new learner and i have communication issue wd english u guys speak. 3 tips gone over my head😀😀 but i will appreciate if u can mail me those tips n more new things if u wish to share.
🙋🙋🙋For a slicer
You can add search option
By clicking 3 dots(...)
You can find search option - double click it
It will added to slicer
My bad, I meant you cant use ctrl+f to activate the search box on the desktop.
/Ruth
Yes, interactions editing is horrible. It should be improved. It’s clear win for MS and power users
You're dead right Ruth. No use to me! BTW, you sound more and more Swedish, did you know :-).
😂😂
I replied to the wrong video. I was referring to SharePoint! Sorry!!
Hey Ruth. Mega useful. Cancel refresh super handy. And Spain is back :)))
Ruth, I have enjoyed your content, and the recent interactivity at the end of the videos was nice. Perhaps one thing you could do is similar to what you were doing with charts before - show a chart (either current or past) and in the comments we can talk about was was good or bad about the way the data was presented. I feel that I always learn a lot about visualization from these types of posts/videos, and the more people commenting the better
That is a good idea and I have some charts ready.
It is great if you can help me find charts to comment and publish them on the discord server for me see :)
Thanks for the Cancel Refresh tip. I have wasted so much time! :-)
I know right? Stunned when I discovered it chance, thought you guys probably want to know too:)