Unboxing DAX Query View in Power BI - Unplugged #54
HTML-код
- Опубликовано: 15 ноя 2023
- Discover the new DAX Query View introduced in Power BI Desktop November 2023. Spoiler: it is a good feature!
Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021...
#unplugged 
Наука
I forgot all the words except Wow! Thanks to the Power BI team for the feature. Thank you Marco for telling us about it in such detail :)
personal bookmarks:
01 | 2:54 : result preview limit.
02 | 5:24 : Suggest Define feature (lightbulb)
03 | 9:00 : zoom feature to watch out for
04 | 10:47 : right click menu options.
05 | 12:33 : “Bugs alerts us to improve and keep improving” (personal mantra)
06 | 19:55 : unformatted results
07 | 21:50 : refreshing the model can sometime
08 | 24:00 : query format bug
09 | 25:25 : adding a measure? Sick!
10 | 30:20 : saved queries on the model (pbix file)
To be continued. Great video!
20.00 totally agree! I would also need a sort button on each column returned by the query.
Please vote!
Kudos to all developer, who developed this amazing feature within PBI desktop.
Great explanation on day one of public release Marco, thank you!
OH MY GOOOOOD, ABILITY TO WRITE AND ADD MULTIPLR MEASURES AT ONE PLACE IN THE SAME TIME, FROM POWER BI. AAAAND CHANGE COLOR OF SLICER.
MY WORKLOAD WILL BE REDUCED BY 95%.
THIS NEEDS CELEBRATION, THIS IS A NEW HOLYDAY
Seeing Marco struggle with the new UI should be enough evidence for Microsoft for rolling back this toggle crazyness for right-side panes :D
The horrible features
Then u r getting old
Finally they did it 😂
Great tutorial Marco ! I would like to add that tools like TE and DAX Studio will shine for enterprise models as you can use XMLA endpoints to query the semantic models from service and run your queries on the entire model vs running it on limited data in desktop.
hopefully they will include the DAX viewer with Live connections at some point!
Awesome feature
I'm so glad Marco looks so happy😂 I've delivered Marco's message to Zoe and the team and I am sure there will be tons of new features to come out soon!
Brilliant as usual , thanks Marco for unboxing this new DAX Query View
I still live in Stone-Age powerbi skill, got to learn this ASAP
Thank you Marco... i loved your comparison of new dax editor to Dax studio.
Very nice!
As with the inline light bulb, MS could use icons next to the line numbers in front of MEASURE to update/add a single measure. And an icon in front of DEFINE to add/update all the measures. Also a right-click > pop-menu on those icons could provide an Undo feature and more.
This is amazing. Great tutorial Marco.
25:35 Nice!!!!!
This is a great feature, so many possibilities!
Great explanation. Thanks.
A very useful analysis. Thanks a lot for sharing your knowledge.
So, PBI new features are promising, but we still need DAX Studio, which is a great tool!
Well done Marco! Clear like crystal
I missed the end music after the "enjoy DAX" :)
This is what happens when we publish a video too quickly! Thanks for noticing, too late to edit it, but we'll pay more attention in the future!!
Not to worry - I sung the outro music myself - out of habit! 🤣
@@SQLBI enjoyed the video anyway.
I am just used to thate music at end of all your videos.
Can't wait for your next videos. Keep it up!
@@SQLBI enjoyed the video anyway.
I am just used to thate music at end of all your videos.
Can't wait for your next videos. Keep it up!
Hi,
Thank you for sharing.
Still I haven't used this feature, but just curious to know whether this works for remote models (with Live connection) ? And does this plan to have a code security too?
After publishing, does this allow user to look/ run/edit the saved queries (not by editing the model in browser, which is available) but as dax query editor on fly to run against the model in which it's saved.
Hopefully will see more features into it but still prefer dax studio for seasoned developer, as it's a matured product.
You cannot delete a measure with a DAX script in TE3 either, right?
Yes, there should be Update model for all the measures. Imagine, you have 100+ measures and make a change with Replace command that affects a few dozens of them. You will have to Update model for every measure changed.
Amazing sir! Thank you.
Thanks for the video . For me it is the best update of this year.
Thanks!!
Very nice to hear about this feature, Great tutorial Sir, but If we are connected to tabular cubes with live connection, I don't see this option under visualization and model view, is it the same for everyone?
It is not currently supported for live connection, but if you enable the composite model (click on "Make changes to this model"...) then it works.
As always,great unboxing..
Very exciting development
A very nice addition (but I think it should have come sooner).
very useful feature! I tried to format a measure with "," in the numbers yet DAX view didn't format accordingly, percentage too didn't work and as a feature when you click on a measure i DAX view it's better when you change to table view, model view and report view to be opened to the same measure (instead of doing a new search)
Hi sir,
Your videos are so informative and very helpful to many people like me. Thank you so much for making such an awesome videos.
Could you please do a video on org chart on power bi for HR data when there are 30+ employees involved in 4-5 levels. Please help.. I’ve been searching a lot on this and didn’t find any helpful article or video on this. Could you please do a video on this. This will be very helpful.
Thank you!
Video is very good. I want to know what software do you use to capture the screem?
ZoomIt, it is a free tool: learn.microsoft.com/en-us/sysinternals/downloads/zoomit
Great feature and great video. OT: your PC is so fast launching DAX Studio from Power BI! My I7 with 32 GB of RAM is a slug in comparison 😥
Excellent 🎉
You also first have to enable the powerbi model explorer and calculation group authoring
Sir, how to display file name along with data.. While get data from csv file through power query
I'm impressed, sondrfully impressed 😊
fyi: can't do on push dataset. presumably can do only on xmla-accessible datasets?
Yes, only for composite models (which are not possible with push datasets).
also? OPENSOURCE A DAX PARSER
excellent
Where we can get the file to practice along
You can use any Power BI Desktop file - any article on www.sqlbi.com also uses a similar model (Contoso), download the sample file from any article.
It is really wornderfull, can we have this dataset for practice
Every article on our website usually has a sample PBIX with data from Contoso - just download one of them!
www.sqlbi.com/articles/
I can export more than 30k records in DAX Studio 😜
Marco, you should sell DAX Studio to Microsoft before they copy all the features 😂😂😂
That’s what they are good at right? 😅
👊 *Promo sm*