Tuesday, March 13, 2018

Power BI Q&A feature in reports

I know I've been lazy in the last six (ok, even more) months... but things have changed around my career a little bit. Don't get me wrong, I am still doing lots of SharePoint stuff, but since last summer I also got involved in some Power BI projects. I've also started putting up a another small blog on Facebook related to my other passion, which is globetrotting.

I got really good insights in the Power BI technology during a full day workshop at the European Collaboration Summit in Zagreb, Croatia last year. Thanks to John White and Jason Himmelstein for the wonderful delivery of the content. It was transferred to hands-on experience starting the day I got back to work.

In the last 9 months, I've got my hands dirty and designed several solutions, based on Power BI reports and dashboards, with data from SharePoint, Exchange Online and other business applications.

To prove I'm seriously into this, today, I have actually passed the now official Microsoft exam:

Analyzing and Visualizing Data with Microsoft Power BI (70-778)


It was the toughest exam I've taken (no kidding!), there were a lot of DAX queries and a mix of admin and developer questions...it was a close one with a passing score of just 745.

Anyway, I wanted to give you some value with this post by telling you about a feature that got released in Power BI Desktop recently... that's the Q & A.

Even on the exam, questions to Q & A referred only to the dashboards in the Power BI service, but this feature is now also available in the reports in Power BI Desktop. Your Power BI desktop client must be at least the December 2017 version... but I recommend you get the March 2018 update.

It's a preview feature, so you'd need to enable it first. You can do that by going to File -> Options and settings -> Options -> Preview features. Tick the Q &A feature, click OK and restart Power BI desktop.


The next time you start your Power BI desktop client, you will see this:


How does the feature work? Pretty simple, you can ask questions about your data in a natural language. Just click on the canvas in Power BI desktop report view and the following visual will appear:


For example, I'll load a dataset of Projects and ask the simple questions.. ok how many are they? Rather than doing a COUNT function with DAX... and boom: I've got the answer.


Now, sometimes, you will not know the exact field name by which to search... let's say you insert a query for top client by revenue, but the field in the dataset is called customer. Here's where the synonyms come into play. I will write another post on how to get the most of those.

So... how many of you are using Power BI? Are there any of you interested on taking the exam?


111 comments:

  1. The advanced world we live in directly is flooded with a wide range of computerized information: information produced through web based life posts Data Analytics Course in Bangalore

    ReplyDelete
  2. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!
    data analytics course

    ReplyDelete
  3. This was really one of my favorite website. Please keep on posting. ExcelR Data Analytics Course Pune

    ReplyDelete
  4. I feel very grateful that i read this.It is very helpful and very informative and i really learned a lot from it.
    learn360digitmg artificial intelligence course

    ReplyDelete
  5. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog.
    learn360digitmg artificial intelligence online course

    ReplyDelete
  6. This is a fantastic website and I can not recommend you guys enough.
    360digitmg ai and machine learning courses

    ReplyDelete
  7. A good blog always comes-up with new and exciting information and while reading I have feel that this blog is really have all those quality that qualify a blog to be a one.
    data science course in guwahati

    ReplyDelete
  8. Really impressed! Everything is very open and very clear clarification of issues. It contains truly facts. Your website is very valuable. Thanks for sharing.
    digital marketing course in guduvanchery

    ReplyDelete

  9. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.
    click here

    ReplyDelete
  10. I am overwhelmed by your post with such a nice topic. Usually I visit your blogs and get updated through the information you include but today’s blog would be the most appreciable. Well done!
    data science training

    ReplyDelete
  11. Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me !data science training in Hyderabad

    ReplyDelete
  12. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    Artificial Intelligence Course

    ReplyDelete
  13. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog. tableau vs power BI | visualization tools comparison

    ReplyDelete

  14. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our site please visit to know more information
    data science courses

    ReplyDelete
  15. This article was written by a real thinking writer. I agree many of the with the solid points made by the writer. I’ll be back. log splitter

    ReplyDelete
  16. The education starts with the study of natural sciences as they relate to computing and then diverges into a study of the specific niche area - such as hardware, software, graphics and information technology data science course in india

    ReplyDelete
  17. That is the excellent mindset, nonetheless is just not help to make every sence whatsoever preaching about that mather. Virtually any method many thanks in addition to i had endeavor to promote your own article in to delicius nevertheless it is apparently a dilemma using your information sites can you please recheck the idea. thanks once more. vliegveld rotterdam bestemmingen

    ReplyDelete
  18. Well articulated.
    I have blogged on a similar topic in my Data Analytics blog - DataisSACRED

    ReplyDelete
  19. This post is very simple to read and appreciate without leaving any details out. Great work!
    data science course in gurgaon

    ReplyDelete
  20. Your content is very unique and understandable useful for the readers keep update more article like this.
    data analytics courses in yelahanka

    ReplyDelete
  21. I see the greatest contents on your blog and I extremely love reading them.
    Best Institutes For Digital Marketing in Hyderabad

    ReplyDelete
  22. Already, the cloud accounts for more than half of all data center traffic, according to Cisco, and that is expected to climb to 76 percent by 2018. Much of the activity so far has focused on the development of private clouds, salesforce training in noida

    ReplyDelete
  23. it’s really nice and meanful. it’s really cool blog. Linking is very useful thing.you have really helped lots of people who visit blog and provide them usefull information.
    Data Science Training in Hyderabad

    I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

    Devops Training in Hyderabad

    Hadoop Training in Hyderabad

    Python Training in Hyderabad

    Tableau Training in Hyderabad

    Selenium Training in Hyderabad

    ReplyDelete
  24. nice blog!! i hope you will share a blog on Data Science.
    data scientist course

    ReplyDelete
  25. Awesome article, I am a big fan of this website, keep on posting that great content, and I'll be a regular visitor for a long time...looking for the next one....keep it up!
    tableau automation

    ReplyDelete
  26. Hi, I log on to your new stuff like every week. Your humoristic style is witty, keep it up
    data scientist training in hyderabad

    ReplyDelete
  27. Power themes We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.

    ReplyDelete
  28. When David and Charlie went into a bakery in Denver Colorado in 2012 to order a wedding cake, they didn’t know they would end up in a court battle with the baker. In February 2019, Anna and Amanda tried to arrange a wedding photographer and ended up on the six o’clock news. Sometimes it seems like we are still living in the dark ages. But now there is THEAPP! We have the technology that will allow us to live our lives peacefully and do business within a community that is kind, tolerant and accepting. THEAPP from LGBTQ.one is a revolution in inclusive geo-social commerce. Dedicated to only those businesses that prefer to do business with the LGBTQ community, THEAPP will guide you to the things you want and need day to day. From Cakes to Photographers, from Dress Makers to Hair Stylists, or maybe just a safe and accepting gathering place, whatever locations and/or services you seek, THEAPP will find it for you and assure that it is a friendly and safe experience. LEARN MORE ABOUT THEAPP

    THEAPP from LGBTQ.one has you covered, whatever you are looking for.

    Looking for someone? THEAPP has a very special feature. Whether it is a brief chat, a meet up for coffee or a long-term relationship you are looking for, THEAPP has the power to bring together people of like interests in an effective, safe and logical way. Similar to the way an entertainment guide alerts you of nearby businesses and deals offered, even when you are traveling, THEAPP keeps a lookout in a circle around you and notifies you when it detects another LGBTQ THEAPP user nearby. LEARN MORE

    But, How does THEAPP work? THEAPP works very much like the commercially available “Entertainment Guide” with two very significant differences. The Entertainment Guide serves the general public and does not distinguish between LGBTQ friendly businesses and those that may in fact be hostile towards members of the community. It is important that our members know they are visiting and patronizing merchants who are accepting and ready to provide an enriching and positive experience. The purpose of THEAPP is to provide a safe and friendly experience for both the merchant AND the members they serve. The other distinction between commercially available Entertainment Guides and THEAPP, is those guides charge you to use them, THEAPP is completely FREE to use and is supported by LGBTQ friendly merchants themselves. CLICK HERE: BISEXUAL

    ReplyDelete
  29. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. click here

    ReplyDelete
  30. Thanks for this great post, i find it very interesting and very well thought out and put together. I look forward to reading your work in the future. 토토사이트

    ReplyDelete
  31. This is the type of information I’ve long been trying to find. Thank you for writing this information. 릴게임

    ReplyDelete
  32. Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers! 먹튀검증업체

    ReplyDelete
  33. I can’t imagine focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material. This is great content. buy youtube views non drop

    ReplyDelete
  34. Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. สล็อตออนไลน์

    ReplyDelete
  35. I think this is one of the most significant information for me. And i’m glad reading your article. But should remark on some general things, The web site style is perfect, the articles is really great : D. Good job, cheers 먹튀검증

    ReplyDelete
  36. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    data scientist training in malaysia

    ReplyDelete
  37. Thank you for helping people get the information they need. Great stuff as usual. Keep up the great work!!! Jeannie Gaffigan

    ReplyDelete
  38. Believe it or not, it is the type of information I’ve long been trying to find. It matches to my requirements a lot. Thank you for writing this information. 파워볼사이트

    ReplyDelete
  39. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. 대전마사지

    ReplyDelete
  40. Great Information sharing .. I am very happy to read this article .. thanks for giving us go through info.Fantastic nice. I appreciate this post. 대전마사지

    ReplyDelete
  41. Though you could spare your self the trouble of getting ready the paperwork's through hiring a 3rd birthday birthday celebration logistics provider issuer with customs broking abilties and great revel in with the port of foundation and vacation spot which you are running with.Shipping from china

    ReplyDelete
  42. At Inovi, we’re committed to achieving the highest success rates while providing personalized care to our patients. Our Houston location offers expert care and is home to our state-of-the-art embryology lab. view it

    ReplyDelete
  43. Your work is very good and I appreciate you and hopping for some more informative posts. Thank you for sharing great information to us. 바둑이게임

    ReplyDelete
  44. This was a really great contest and hopefully I can attend the next one. It was alot of fun and I really enjoyed myself.. https://abercrombieand-fitch.com.co/

    ReplyDelete
  45. Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place.. shuttlesky.in

    ReplyDelete
  46. I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well. 대전건마

    ReplyDelete
  47. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. https://sites.google.com/view/buy-twitch-followers/

    ReplyDelete
  48. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. 바둑이

    ReplyDelete
  49. I might suggest solely beneficial in addition to trusted facts, and so find it: 토토사이트

    ReplyDelete
  50. This content is written very well. Your use of formatting when making your points makes your observations very clear and easy to understand. Thank you. 토토사이트 인디벳

    ReplyDelete
  51. I really thank you for the valuable info on this great subject and look forward to more great posts
    data scientist certification malaysia

    ReplyDelete
  52. If more people that write articles really concerned themselves with writing great content like you, more readers would be interested in their writings. Thank you for caring about your content. 환전가능 꽁머니

    ReplyDelete
  53. Pretty good post. I have just stumbled upon your blog and enjoyed reading your blog posts very much. I am looking for new posts to get more precious info. Big thanks for the useful info. 토토사이트

    ReplyDelete
  54. If you are looking for more information about flat rate locksmith Las Vegas check that right away. Nagaland State Lottery

    ReplyDelete
  55. The way you write, you are really a professional blogger. Y-Ymovies

    ReplyDelete
  56. I have read your article couple of times because your views are on my own for the most part. It is great content for every reader. 오피아트

    ReplyDelete
  57. Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. 먹튀검증사이트

    ReplyDelete
  58. Sex Videos - Loans bad credit no guarantor - Bad Credit History offers guaranteed loans for people with very bad credit from £500 up to £75000 with no guarantor, credit check, broker and no fees.

    ReplyDelete
  59. This web-site is actually a walk-through you discover the knowledge you wished in regards to this and didn’t know who need to. Glimpse here, and you’ll certainly discover it. 바카라사이트

    ReplyDelete
  60. I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people.
    data analytics course in hyderabad

    ReplyDelete
  61. A while the remarks are approved at promptly and sometime the comment predicted as comment spam or moderate it for approval. Do comply with blogs are very really hard to uncover and won’t be able to manage to reduce that our responses turn into spam and unapproved. There are several points. 꽁머니

    ReplyDelete
  62. Nice to be visiting your blog once more, it has been months for me. Well this article that ive been waited for therefore long. i want this article to finish my assignment within the faculty, and it has same topic together with your article. Thanks, nice share. how to start a credit card processing company

    ReplyDelete
  63. I’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. blissy luxury pillowcase review

    ReplyDelete
  64. I read your blog frequently and I just thought I’d say keep up the amazing work! North American Bancard Agent Program

    ReplyDelete
  65. Please let me know if you’re looking for a author for your site. You have some really good posts and I believe I would be a good asset. If you ever want to take some of the load off, I’d really like to write some content for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Regards! 안전놀이터

    ReplyDelete
  66. Great post, you have pointed out some fantastic points , I likewise think this s a very wonderful website. North American Bancard Sales Partner

    ReplyDelete
  67. Keep up the good work , I read few posts on this web site and I conceive that your blog is very interesting and has sets of fantastic information. How to Sell Merchant Services

    ReplyDelete
  68. I’ve been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the web will be a lot more useful than ever before. best time to buy crypto during the day

    ReplyDelete
  69. Find the best essays on is my friend's profile page. 몰디브바둑이

    ReplyDelete
  70. Fumigation Services sargodha If termite is a nightmare for you then Tahir termite control services in Lahore is giving you the best offer.Pest Control Service sargodha

    ReplyDelete
  71. I hope many people know good information here. I will put favorites. 먹튀보증업체

    ReplyDelete
  72. Nice information, valuable and excellent design, as share good stuff with good ideas and concept 스포츠토토사이트

    ReplyDelete
  73. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article 안전한놀이터

    ReplyDelete
  74. A great website with interesting and unique material what else would you need.
    full stack web development course

    ReplyDelete
  75. How to Deal withYahoo Mail Not Working?

    There are times when users encounterthen Yahoo mail not working then start by clearing off cache and cookies. Another tip is to clear the browser’s cache and cookies that are stored information can be cleared from the browser. By cleaning the browser, you can instantly improve the experience with the Yahoo webmail browser-based version.Follow these steps properly and check out whether your Yahoo mail not working issue is resolved or not.These are the steps that you need to follow to troubleshoot the issue of Yahoo mail not working issue is resolved.

    Read More:- Yahoo mail not syncing

    ReplyDelete
  76. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often. Muama Ryoko device

    ReplyDelete
  77. Verizon email not syncing issue is usually experienced by users with several devices. It happens if the web browser you are using has a lot of caches. So, if you are using Verizon email not syncing issue, go to the settings option of your android device and select the "Application" option. Then go to the "Manage Application" option followed by the "All" tab option.

    ReplyDelete
  78. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... Dentitox pro review

    ReplyDelete
  79. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. Dentitox pro review

    ReplyDelete
  80. https://www.buyyoutubesubscribers.in/2021/12/20/how-many-views-on-youtube-to-make-money/ Search for "youtube network marketing videos" and at the time of this writing you are going to find more than 287,000 of them. Add MLM to the mix and you will come up with over a half million videos obtainable using the network marketing niche ranging all the way from horrible to amazing.

    ReplyDelete
  81. I can’t believe focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material without a doubt. It is one of the greatest contents. สล็อตฟรีเครดิต

    ReplyDelete
  82. I exploit solely premium quality products -- you will observe these individuals on: 릴게임사이트

    ReplyDelete
  83. https://dynamichealthstaff.com/jobs-in-dubai-for-nurses In basic layman terms SEO means search engine optimization. Done correctly, it can make a website appear on the first page or even higher in ranking on popular search engines such as Google, Yahoo! and Bing.

    ReplyDelete
  84. You bear through a awesome vacancy. I sanity definitely quarry it moreover personally suggest to my buddys. I am self-possessed they determination be benefited from this scene. 토토커뮤니티

    ReplyDelete
  85. This is exciting, nevertheless it is vital for you to visit this specific url: 토토커뮤니티

    ReplyDelete
  86. https://hostinglelo.in Blog commenting can bring you tons of traffic to your site. The key is to comment on high-profile blogs. They have thousands of readers and the best way to increase traffic to your site is to position yourself in front of as many people as possible.

    ReplyDelete
  87. This is the proper weblog for everyone who wishes to find out about this topic. You already know a lot its virtually difficult to argue with you (not that I just would want…HaHa). You certainly put a fresh spin with a topic thats been discussing for many years. Excellent stuff, just fantastic! 토토커뮤니티

    ReplyDelete
  88. It was a very good post indeed. I thoroughly enjoyed reading it in my lunch time. Will surely come and visit this blog more often. Thanks for sharing. detective españa

    ReplyDelete
  89. It's never past time to begin a YouTube channel. In the event that you want verification, simply ask these seven makers who've acquired a large number of supporters in only a couple of months. On the off chance that you haven't begun a YouTube channel yet, this moment's the opportunity. buy youtube watchtime

    ReplyDelete
  90. I am happy to find this post Very useful for me, as it contains lot of information. I Always prefer to read The Quality and glad I found this thing in you post. Thanks agen bola

    ReplyDelete
  91. Hi there, I discovered your blog per Google bit searching for such kinda educational advise moreover your inform beholds very remarkable for me. 토토사이트

    ReplyDelete
  92. If you don"t mind proceed with this extraordinary work and I anticipate a greater amount of your magnificent blog entries data analytics course in mysore

    ReplyDelete
  93. It’s very informative and you are obviously very knowledgeable in this area. You have opened my eyes to varying views on this topic with interesting and solid content.
    Health

    ReplyDelete
  94. It is now possible to download Microsoft Excel 2007. The License Key 2003 appears to be very authentic. With all its capabilities, Office 2007 With Key Download

    ReplyDelete
  95. Beyond Compare License Key is focused. It allows you to quickly and easily compare your files and folders. By using simple, powerful commands Beyond Compare 3 Key

    ReplyDelete
  96. I have read many data science posts online previously, but none has managed to captivate my attention like this one. This is truly a masterpiece, and a perfect guide for all data science aspirants. Thanks to the writer for spelling out the concepts clearly, and using just the right words and structure.best data science institute in nashik with placement

    ReplyDelete
  97. The dedication to offering individualized service is one of the things I value most about Go Big LA. They take the time to learn about your company and your objectives, and they customize their services in line with that information. Reach your target audience by getting in touch with their expert digital marketing consultant.

    ReplyDelete
  98. V informative article. Thanks for sharing this
    water parks karachi

    ReplyDelete
  99. Thanks for sharing such great information. It really helped me. I always search to read the quality content and finallyfound this in your post. keep it up!
    architect in agra

    ReplyDelete
  100. That is nice article from you, this is informative stuff. Discover top-quality online tuition for GCSE classes with Ziyyar Edutech. Our dedicated platform offers comprehensive GCSE online tuition, providing students with expert guidance and support.
    For more info visit Online tuition for GCSE

    ReplyDelete
  101. Informative post. Glad to find your blog. Thanks for sharing. Join Our Online English Class in Qatar! Navigate the nuances of pronunciation, conquer crosstalk challenges
    For more info visit Online Tuition for english language in Qatar

    ReplyDelete