Power BI Update - November 2023

Welcome to the November 2023 update. We’ve got a lot of great features this month including DAX Query view, Semantic Model Scale-out, and Advanced Filtering for Paginated Reports.
Reporting: 0:56
Modeling: 7:36
Data Connectivity: 9:57
Service: 10:16
Embedded Analytics: 14:58
Visualizations: 15:04
Other: 15:39
Community member spotlight: 15:50
Follow us on Twitter - / mspowerbi
More questions? Try asking the Power BI Community @ community.powerbi.com/
#microsoft #powerbi

[@kishore_p93]

One of the best updates in Power BI this year. Excited and can't wait to try out all the new features. Especially the DAX query view feature derived from DAX Studio!

[@MicrosoftPowerBI]

We're so glad to hear that, Kishore! You'll have to circle back and let us know your thoughts once you give it a try! 💛

[@elrevesyelderecho]

9:30 This is insane! Excellent! Can you add more features from Dax Studio to this new view? Thanks

[@BaldBookTuber]

The inline DAX Query feature is long over due and awesome. Very interested for the blog post to learn more about features like Button Slicer that are sort of glossed over in this video.

[@Anttsa90]

I have one request. Can you please tell the team writing the feature blog to scale down the copilot/chatGPT textfluff that has recently inflated the Feature blog. It really does not give any additional value to the description of features/changes. ", you and your users will be astounded by the world of wonder they unlock. "Brace yourself for the November upgrade" ".will open a world of versatility and a new era of data visualization!" "this November upgrade will keep you smiling from ear to ear!" "we’re equally excited to share Power BI’s second exhilarating advancement " "...will help drive awareness of the unparalleled capabilities provided."

[@MicrosoftPowerBI]

Thank you for the feedback, Anton!

[@Tom-kp2lv]

Agreed - you skipped right over potentially useful features (what's a button slicer?) and spent lot of time on this useless, fledgling AI stuff.

[@just1live]

Great update! I love when you include short demo to introduce new features

[@giorgikvatchadze4928]

The DAX query update is one of the most important, useful, and fundemanetal updates in recent memory. The fact that I can now create calculation groups, particularly time intelligence formulae, directly in PowerBI is really awesome!

[@MicrosoftPowerBI]

We're so glad that you can enjoy Power BI even more now!

[@LearnAtHomewithGulshan]

The DAX query view is excellent because, often, we lack access to other third-party tools in office.

[@MicrosoftPowerBI]

We're glad you're enjoying it!

[@rashidanwar7831]

DAX query feature is the best! Please add a dark mode feature for both, powerbi desktop and service. That is going to easy on eyes and also an energy saver 🙂

[@MicrosoftPowerBI]

DAX query is the best 💛 You can leave your feature request here: Power BI: msft.it/6058iDoOE

[@rashidanwar7831]

@@MicrosoftPowerBI done!

[@catalinamurcia4424]

It's true... We need the dark mood... It will be more nice if it's in power Bi desktop!

[@MicrosoftPowerBI]

💛

[@MicrosoftPowerBI]

Hi there, thanks for your feedback! We recommend that you submit your feedback here: msft.it/6050iE3aA

[@charlesdelanoy]

Love the explorer (preview) feature in the service ....this could fit a number of self serve scenarios

[@MicrosoftPowerBI]

💛

[@Bharath-Raju]

"Explore this data" will help a lot, for many employees to create quick reports and to share data. If there is an option to export to csv, excel or pdf will be more helpful. Thankyou Power BI team.

[@TheTikeySauce]

The DAX Query View is insane!

[@user-df6nx1lg3f]

Thanks for making the update a bit more descriptive and less perfunctory. I like the DAX Query editor. Although i've enabled the query editor in Preview, I don't see the "Quick Query" option as in the video. When will that be released, or do I need to set another preview feature. (I think I've enabled them all)

[@user-df6nx1lg3f]

Right, I see now, you have to be in the editor.

[@stewartthomson3729]

Great updates! My feedback for the videos would be could they be more visual? For example, we had the editors pick of the quarter on some cool visualisations, wouldn't it be better to actually show these in action in Power BI or at the very least an actual image of them.

[@islamabdel-ghany2564]

Explore is an awesome feature, adding co pilot to it to answer questions will be be perfect

[@rendon102]

Great update. The new DAX query is the same to DAX Studio?

[@luisfernandomacedo1451]

Wow, so many updates. Liked the new built-in Dax Query feature.

[@MicrosoftPowerBI]

💛

[@simona7517]

Dax Viewer and sample previews, both great additions.

[@MicrosoftPowerBI]

💛

[@billfarmwald8034]

Thanks for these feature update videos. It's a great way to visualize the interaction and use-cases of the features.

[@MicrosoftPowerBI]

You're welcome! We're glad you found them helpful 😃

[@hishnick79]

Extremely power updates especially DAX editor !! Always the beat

[@kumarvg5383]

Thanks for the Amazing updates... Keep rocking and end this year with a great note 📝

[@MicrosoftPowerBI]

You're very welcome, Kumar! 🥳

[@workstuff5253]

Christmas is coming early!! I would love the ability to undock the panes and move them outside of the desktop app - to move them to another monitor for example.

[@MicrosoftPowerBI]

'Tis the season! 🎁 Thank you for the suggestion, we encourage you to give your feedback directly to our developers, you can do so here: msft.it/6058iDAuy

[@EverythingPants]

I can't see the copilot option in Narrative. I've enabled the preview features and the tenant settings accordingly. Is anyone else having this issue? (I also do not have the copilot icon on the top bar next to "Explore Data" either!?)

[@MicrosoftPowerBI]

Hi there! We were experiencing technical issues before, however, it has since been resolved. Are you able to see the Copilot option now?

[@EverythingPants]

@@MicrosoftPowerBI No it's still not there. Do you need a certain license and/or premium capacity (we're using Embedded currently)

[@Ultramarplogic]

Awesome updates!! The Dax Viewer is a huge help.

[@MicrosoftPowerBI]

We think so too! 😉

[@Gooodies]

Amazing update 🎉🎉 . Just add Page Level and visual level rls and Power Bi become unbeatable.

[@MicrosoftPowerBI]

We're so glad you think so!🥳💛

[@raeesg]

Would it be possible to please do a preview of each feature in the video rather than just read it out?

[@elizabethspicuzza4442]

Great update but not seeing Copilot Narrative in Desktop (I enabled it in preview features and restarted) or in the web service. Is this preview available for all Power BI users?

[@MicrosoftPowerBI]

Hi Elizabeth, you should be able to access Copilot Narrative. We have some information here to help you out: msft.it/6053iE3LZ

[@ManishSingh-ds3qn]

One of the best update is Explore the data in services, thanks!

[@juanfelipe6341]

Amazing updates , but I need soon Dark mode pls xD

[@anthonycipolla8630]

Long awaited update 🎉 thankyou Power BI team! ❤

[@MicrosoftPowerBI]

You're so welcome, Anthony! We hope you enjoy the updates.💛

[@jonschettler7285]

We can't seem to see the new explore feature, is there a tenant level setting that must be enabled to view this in the service? Otherwise very excited for this update!

[@MicrosoftPowerBI]

Hi there! We were experiencing technical issues before, however, it has since been resolved. Are you able to see the new explore feature?

[@paulgallagher2987]

@@MicrosoftPowerBI I can't see the "Explore" Option either.

[@danielshapiro9613]

I don't see the explore option either. Using a Pro capacity workspace. @@MicrosoftPowerBI

[@catalinamurcia4424]

For sure the DAX query view it's gonna be the best!!

[@MicrosoftPowerBI]

🥳 🎉

[@user-fv4ys8sr7f]

When I try the Narrative Smart button in the Power BI Service (Edit Mode on), it does not open the Copilot button... Do I have to configure it up somewhere? Thanks a lot!

[@bryanchaves5691]

Try enabling the preview feature in settings and re starting power BI

[@OrpheusObjectMRH]

Love the data connector updates!

[@MicrosoftPowerBI]

We're happy to hear it! 🤗

[@stephengessling7645]

Christmas came early this year, thank you!

[@MicrosoftPowerBI]

🎁 😉

[@sybamunki]

can't wait to get the copilot summary feature

[@snifrbelin]

DAX query view is a excellent addition.

[@MicrosoftPowerBI]

We think so too! 🤗

[@user-ei3qo3dq9v]

Hi , I could not able to see most of the updates. Do I need to update again?

[@sayyadabdulmugani8829]

I didn't get an update in the app store yet, what can be the issue?

[@Patiencelad]

Resolution says 1080p, but parts 3:22 look like 480p. Why?

[@michaeltondu5189]

When are these features going to be available on PBI desktop?

[@sherryh611]

DAX Query view tops it for me.

[@MicrosoftPowerBI]

🥳 🙌

[@chad_the_stud]

Create something like charticulator again or allow interactive python libraries like plotly, datashader, bokeh to allow users to create simple visuals that should have existed in power bi in the first place ! Show R squared value in scattter chart trend line. Create a cloud version of desktop app that doesnt consume local resources Enable version control Allow us to freeze slicers on top of the page so users dont have to scroll back and forth Bring a custom slicer panel feature Allow us to join table on multiple columns When adding a new visual, dont populate on top of the page ! Put it where users cursor is

[@Herbieatorbie66]

I am new to Power BI and learning a lot of cool stuff. But.... just when I am starting to get used to some options, I now got lost and can't find some of the features. For example: How to get a trendline in a linechart? Cannot find it anywhere

[@noahhadro8213]

I just downloaded the new update. I do not see the new slicer visual. I also don't see the ability to turn it on in the options? I also don't see the new dax editor experience?

[@Jules-69lol]

You have to enable them in the settings, as they're preview features

[@Wzxxx]

Nice. I love the simple update of right pane. Still missing a dark mode. My eyes scream as I use PBI a lot. No idea why ppl are so excited about dax query.

[@guillermochavez7275]

I have downloaded the setupX64 from the Nov 23 link, but it keeps installing the October 23 version. Help!

[@rashidanwar7831]

It is being said that copilot in power bi service feature is only available for F64 or Premium capacity and higher. However, we are still unsure about the precise cost. F64 requires a reservation fee of about $5,000 per month and a pay-as-you-go rate of more than $8,000 per month. Premium capacity charges around $5,000 monthly. So, does this mean that anyone who can pay $5,000 a month can access this feature? Is that correct?

[@denwo1982]

Just waiting for manager to say tomorrow morning ... "Have you got two minutes" P45 on your desk

[@JoaoLucas-wk2sf]

Inside the new card, when I have data and I want to put a label that has a detail in percentage, power bi is not understanding the percentage! please fix this... when I add the percentage, for example 22%, the value stays at 0.22 even though the measurement is formatted as a percentage!

[@yogeshthorat732]

Explore dataset is great new addition

[@MicrosoftPowerBI]

That seems to have everyone excited!💛

[@user-py3co6lq2d]

It will be really appreciated if we can bring the total columns in the matrix as the first set of columns

[@MicrosoftPowerBI]

Hi, thanks for the suggestion. We encourage you to submit your feedback directly to our developers; you can do that here: msft.it/6057iTfAd

[@__HumanBeing]

The DAX Query update is... well, just great. Thank you Microsoft!

[@MicrosoftPowerBI]

We're so glad you like it! 💛

[@user-th4mr6sd7p]

Can you share the power bi file used in this video?

[@AlexandroVieiraLopes]

video muito bom

[@abhimalhotra8358]

Is show value as removed. ?

[@MicrosoftPowerBI]

Thanks for reaching out! Can you please clarify your question? We're here to help!

[@Jack2of3]

I installed the update and seem to have lost the ability to save as to my local drive. Is this a "Feature"?

[@devinpikafire]

🎉

[@arameshkumar5072]

so cool updates this month 💕💕💕💕💕💕

[@MicrosoftPowerBI]

We're glad you're enjoying our updates 💛

[@coderover-cr]

I don't have Dax Query, how to turn on (I completed update today)

[@MicrosoftPowerBI]

Hi there, by using SQL Server Management Studio (SSMS), Power BI Report Builder, and open-source tools like DAX Studio, you can create and run your own DAX queries. We have some information here to help you with creating your own: msft.it/6058iEMeu

[@jerigurl04]

has anyone had any luck finding the reference labels?

[@szklydm]

It's for the new card visual

[@mattmatt245]

When will Copilot become publicly available ? Quick measures suggestions and dashboard creation is still in a preview mode.

[@wowrb]

when is the copilot release for private users?

[@MicrosoftPowerBI]

Hi there, thanks for reaching out. We will share more about availability in the coming months. Stay tuned! 💛

[@xenon2106]

Wow

[@MicrosoftPowerBI]

🥳

[@jackobrien8015]

I was previously able to create and edit measures in a dashboard that is connected to a live data model. Since this update, this feature has not been functional. Manual measures that I had previously created are frozen and I am not able to create any more. Is this how the app is supposed to function, or is this a possible bug within the update?

[@MicrosoftPowerBI]

Hi there, thanks for reaching out. This looks like a great question for our Tech Community where other community members and experts can take a look and provide suggestions. You can post your question here: msft.it/6051iPjfF

[@spilledgraphics]

amazing amazing amazing!!

[@MicrosoftPowerBI]

We're pretty excited about it, too! 😜 🥳

[@Tom-kp2lv]

Why skip right over button slicer and reference labels without a quick demo? Likewise support for direct lake? It seems MS is more interested in promoting flashy bells and whistles than actually useful functionality. And On Object editing is still an abomination. When the best update to it is to make it more like the legacy version, that should tell you something. And if I want to run queries I can use dax studio. But I rarely do. I'm not sure I see any great value in adding the dax query pane.

[@amardeepbhingardeve9903]

Please upload new .exe file to download center

[@romancherevatenko5658]

Best!

[@GTOUranus]

WORKSPACE FOLDERS

[@rkandathil]

The past few updates have been 🍌🍌🍌

[@MicrosoftPowerBI]

We're glad you're enjoying all the updates!

[@andreanikitacavaletti9761]

Explore feature ;)

[@alaa.81]

super cool 🦸‍♂

[@MicrosoftPowerBI]

We can't wait for you to try it out! 🥳