Copilot for Power BI: Your Ultimate Copilot Guide

Ғылым және технология

Have you used Copilot for Power BI? Do you know there are different copilots within Power BI? Carly joins us for the ultimate Copilot for Power BI guide!
Overview of Copilot for Power BI (preview)
learn.microsoft.com/power-bi/...
Create report pages with Copilot for the Power BI service
learn.microsoft.com/power-bi/...
Create a narrative with Copilot for Power BI
learn.microsoft.com/power-bi/...
Summarize a report page in the Copilot pane
learn.microsoft.com/power-bi/...
Use Copilot to create measure descriptions (preview)
learn.microsoft.com/power-bi/...
Connect with Carly Newsome
/ carlylanders
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Copilot #GuyInACube

Пікірлер: 132

  • @davidcousins8407
    @davidcousins84072 ай бұрын

    The DAX bits alone made my socks fly off. That diff view is genius

  • @MaorAviad
    @MaorAviad2 ай бұрын

    Amazing content! would love to see a more detailed look on how to use Copilot in creating reports and dashboards

  • @kukeleku13
    @kukeleku132 ай бұрын

    The diff functionality in DAX editor is really cool. Will help a lot with understanding new ways of doing things.

  • @1yyymmmddd
    @1yyymmmddd2 ай бұрын

    I believe all these nice things are available on Fabric only and on plans that cost over 5000 USD/month, isn't it?

  • @brycedwhite1

    @brycedwhite1

    2 ай бұрын

    Absolutely correct... and way out of range for almost all small-midsize organizations.

  • @robertnewsome4905
    @robertnewsome49052 ай бұрын

    Amazing!! What a great demo, thanks Carly!

  • @charlesdelanoy
    @charlesdelanoy2 ай бұрын

    Love this great progress - its exactly what we want to see

  • @sivavaraprasadgampala4856
    @sivavaraprasadgampala48562 ай бұрын

    Thanks Carly that's a great demo

  • @StephaneSimeon
    @StephaneSimeon2 ай бұрын

    I actually like to use Ableton more than Logic Pro because of you. Big cudos to you for this video right here

  • @yosephamsalu16
    @yosephamsalu16Ай бұрын

    This is incredibly amazing.

  • @johnfromireland7551
    @johnfromireland755113 күн бұрын

    Completely blown away!! So useful!! And how does MSFT release these major upgrades so fast?!

  • @gvasvas
    @gvasvas2 ай бұрын

    Great demo!

  • @thomasivarsson1291
    @thomasivarsson12912 ай бұрын

    I would like to see what happens with Copilot when you have an ugly baby semantic model. Great demo but I assume that it requires an almost perfect model.

  • @thomasivarsson1291

    @thomasivarsson1291

    2 ай бұрын

    I'm not worried. Instead there will plenty of work to correct ugly babies models for this to work.

  • @stevefox7469

    @stevefox7469

    2 ай бұрын

    This would definitely be an interesting challenge. I would also be curious to challenge it with Optimising DAX.

  • @kolturraghavenderrao6520

    @kolturraghavenderrao6520

    2 ай бұрын

    Yes optimization is an important factor which everyone wants to see how it will get automated

  • @gmurtaza

    @gmurtaza

    2 ай бұрын

    My question exactly! A lot of my stakeholders are hesitant with real life business cases because this requires a model that is built precisely to be handled by Copilot

  • @stevecassell

    @stevecassell

    2 ай бұрын

    Would also be nice to see something other than sales for once.

  • @mattheosprotopapas3286
    @mattheosprotopapas32862 ай бұрын

    Great stuff! it's going to change how BI reports are authored and used.

  • @dsswooshy

    @dsswooshy

    2 ай бұрын

    Explain how? Human developer creates a fact table and star schema. Or multiple fact tables and a constellation schema. AI doesn't do it any differently, it just puts it together in a worse way for people that can't do it themselves.

  • @RichardG-hl9ef
    @RichardG-hl9efАй бұрын

    Great video. Is this only available in PBI Premium? Not in Service?

  • @user-od5fq9kq8e
    @user-od5fq9kq8e2 ай бұрын

    Looks useful information, thanks

  • @PalantirM
    @PalantirM2 ай бұрын

    Waiting for copilot for devoloping also Paginated Reports ;)

  • @gyorgybalogh3194
    @gyorgybalogh31942 ай бұрын

    Amazing demo!

  • @SundayOkoh-qn1ps
    @SundayOkoh-qn1ps9 күн бұрын

    this is interesting, beautiful Co pilot integration

  • @ekinbasha7081
    @ekinbasha70812 ай бұрын

    It really Insane, Amazing!!

  • @asanudo
    @asanudo12 күн бұрын

    very good video. thanks 🙂

  • @pamelacarbonara9876
    @pamelacarbonara987623 күн бұрын

    you're so great guys!!

  • @thomasgehrke5879
    @thomasgehrke58792 ай бұрын

    "A copilot and a function walk into a var"! - Carly and Rein haha!

  • @skeletor4115
    @skeletor4115Ай бұрын

    She has a lot of energy and good vibes.

  • @wassammasood7787
    @wassammasood77872 ай бұрын

    Carly was super cool🐞

  • @kurcel52
    @kurcel522 ай бұрын

    Q: is it possible to use Copilot chatbot within MS Teams. Idea is that We would like some key users ask insights without opening BI reports. Mostly executives. Thanks.

  • @bonganinkambule1921
    @bonganinkambule19213 күн бұрын

    really amazing especially DAX

  • @ugochukwunwasuruba1356
    @ugochukwunwasuruba13562 ай бұрын

    Ok this is amazing

  • @SachKol
    @SachKolАй бұрын

    I have a question(from the perspective of a E-Vendor at Microsoft)! When I used extensions to work on my measures of PBI before copilot came out, it wasn’t able to parse through some data cause those tables were protected by MSFT, but if I use copilot on the same, will it be able to process the protected data from sources like Dim_MarketingLead table, or the ONESMBAS Cube, etc.? And is it ethical to do so?

  • @rajkapil170
    @rajkapil1702 ай бұрын

    This is amazing, Can we control/cap % of CPU consumption allowed by Copilot so that critical report performance are not affected?

  • @vivmaha

    @vivmaha

    2 ай бұрын

    It is mostly a different set of CPUs (GPUs) that will power Copilot. So your report performance will largely be unaffected.

  • @rudy-rr1cg
    @rudy-rr1cg2 ай бұрын

    wow es increible

  • @rhodreque8155
    @rhodreque81552 ай бұрын

    can it be used for data analysis? full analysis and output report creation?

  • @Karenshow
    @Karenshow2 ай бұрын

    You made me smile, wait " I am a new person"

  • @piotr5517
    @piotr55172 ай бұрын

    Is that functionality already available to users in Europe?

  • @abhijithdsouza8091
    @abhijithdsouza8091Ай бұрын

    when will this be available in a thin report connected to an enterprise model ?

  • @user-od3rl5mc
    @user-od3rl5mc20 күн бұрын

    Is there anything similar for Model documentation? - Is there are way to highlight differences from one version to another.

  • @mathew9665
    @mathew96652 ай бұрын

    how much of this is behind additional pay walls - beyond standard pro licence?

  • @sivavaraprasadgampala4856
    @sivavaraprasadgampala48562 ай бұрын

    When will we get Copilot into powerbi desktop ? Is it with free version PBI app or not?

  • @sahilkothekar9927
    @sahilkothekar99272 ай бұрын

    Great demo. Iam curious to know how the narrative visually actually summarise the page ( does it scrapes the data and visual on canvas) and how it provides citation like does it have the visual id refrence with it

  • @vivmaha

    @vivmaha

    2 ай бұрын

    Correct, we scrape the visual data that is already visible to the viewers of the report. We do not go to the data in the underlying semantic model, but perhaps we will in the future. Also correct on the citations. We keep the data tagged with the visuals they came from, so that the responses can help the user to understand where the summary is coming from.

  • @lemps81

    @lemps81

    2 ай бұрын

    Pulling from the model would be challenging if using RLS though right? I wouldn’t want the risk of exposing insights from data the user shouldn’t have access to.

  • @vivmaha

    @vivmaha

    2 ай бұрын

    @@lemps81 100% if and when this is implemented it’ll respect RLS and OLS.

  • @lemps81

    @lemps81

    2 ай бұрын

    @@vivmaha amazing. Looking forward to getting going with it!

  • @SergiyVakshul
    @SergiyVakshul2 ай бұрын

    "Feel free to play around with it. This is in public preview now". Am I right I won't be able to play with it until I have one of paid SKUs: F64 or higher, or P1 or higher? Is there a free option for testing this feature?

  • @wassammasood7787

    @wassammasood7787

    2 ай бұрын

    by the looks of it , no

  • @ProtoZotorP

    @ProtoZotorP

    5 күн бұрын

    You can limit the cost by creating the F64 and pausing it whenever you're not using copilot (won't help with report consumers but at least for the report creation)

  • @tusharj1953
    @tusharj19532 ай бұрын

    Q. Is description generator available for generating multiple measures description also for calculated columns?

  • @vivmaha

    @vivmaha

    2 ай бұрын

    Multiple measures are a great idea. Keep an eye out for it.

  • @MDVIPBilling
    @MDVIPBilling2 ай бұрын

    How do we enable these features? What type of license is needed to avail all these features? Do we need a Premium Capacity license or Premium license? Do we need to get Copilot additional license by Microsoft which cost $30/month?

  • @Gandalf1969Guy

    @Gandalf1969Guy

    2 ай бұрын

    Exactly my questions.

  • @davelaff73

    @davelaff73

    2 ай бұрын

    So, yeah, anytime I want to use the "Copilot" function in my PBI service environment, it essentially tells me that I need to have a Premium Capacity license. Premium Per User licenses don't count. (Yet?)

  • @user-ho1jm6nk9n

    @user-ho1jm6nk9n

    2 ай бұрын

    Yeah this kind of information would be nice to have in the video...Pretty misleading that they said everyone in powerBI can use it.

  • @hahuyhung5248
    @hahuyhung52482 ай бұрын

    In order to use Copilot in PowerBI, do I have to get Fabric licences? It means I will need to pay around $300/ month to use Copilot, right?

  • @kennethwaynescott8469

    @kennethwaynescott8469

    2 ай бұрын

    Pretty sure you need a Fabric license and at least a F64 SKU (equivalent to a P1). So, it's pricey. However, you can turn it on in off in Fabric. So you could just turn it on for an hour here and there to play around with and then turn it back off. Wouldn't think that would be too pricey. But MAKE SURE that if you do this, you turn the Fabric capacity off when you're done playing around. Or you will not be happy at the end of the month.

  • @igorwojak
    @igorwojak2 ай бұрын

    Q: When will msft open this to the $10 tier users so we can at least gauge the viability of this feature before plunking 5 grand per month. In a limited capacity, of course.

  • @kennethwaynescott8469

    @kennethwaynescott8469

    2 ай бұрын

    With the compute costs of it, I'm not holding my breath that it will be any time soon. Could be wrong, of course.

  • @cyb3rcub
    @cyb3rcub2 ай бұрын

    Would like to know when the copilot narrative visual will be functional within a PBI Embedded SKU…

  • @vivmaha

    @vivmaha

    2 ай бұрын

    Not sure. Which embedding are you interested in? Embed for your customers, or for your org?

  • @satishyvv1234
    @satishyvv12342 ай бұрын

    Will it replace power bi jobs ,i mean High level management people will be able to create power bi report's?

  • @vivmaha

    @vivmaha

    2 ай бұрын

    (personal opinion) Copilot will help existing report creators. It'll remove the mundane. It'll provide inspiration. Just like calculators didn't get rid of accountants.

  • @mattmatt245
    @mattmatt2452 ай бұрын

    Where will it all be available in free version ?

  • @wiseguy9587
    @wiseguy95872 ай бұрын

    is it possible to use a specific theme for reports generated with copilot?

  • @lemps81

    @lemps81

    2 ай бұрын

    I’ve seen a demo where you ask copilot to “make it look like report X” and it changes the whole look and feel in seconds.

  • @canasman11
    @canasman112 ай бұрын

    Can I use this Copilot in a PPU workspace capacity? it does not look like it.

  • @davelaff73

    @davelaff73

    2 ай бұрын

    No, you can't.

  • @user-pj1os6kh6c
    @user-pj1os6kh6c2 ай бұрын

    How do we get access to this feature?

  • @smith9808
    @smith9808Ай бұрын

    Dont you need the licence type that costs like $3000 a month to get this at the moment??

  • @MegaProcrastinating
    @MegaProcrastinating2 ай бұрын

    In AUD this is 15,000 per month I hope they release a cheaper version soon!

  • @napaankur
    @napaankur2 ай бұрын

    @microsoft When can we get that in India

  • @Gunterlund583
    @Gunterlund5832 ай бұрын

    my workspace keeps saying workspace isnt compatible with copilot. Ive got it enabled in the tenant. What am I missing?

  • @brycedwhite1

    @brycedwhite1

    Ай бұрын

    Did you ckeck ypu SKU? You need to be licensed for either F64 or P1. Will not work with the ftrr trial licsnse.

  • @daustonian9331
    @daustonian93312 ай бұрын

    How does the regular person get this in fabric? 10k a year?

  • @stevefox7469

    @stevefox7469

    2 ай бұрын

    It kicks in at F64 or P1 . A P1 is $5k per month.

  • @daustonian9331

    @daustonian9331

    2 ай бұрын

    @@stevefox7469cough cough!! So we start the age of the have and have nots in tech. At least we will really know how it works, I guess..

  • @stevefox7469

    @stevefox7469

    2 ай бұрын

    @@daustonian9331 Also a lot of busineses won't be able to use it due to data soverignity issues - if they aren't comfortable with copilot processing the data in the US or France. This is a show stopper for us. Also looks like it is a CPU hog- if you have 20 copilot users on a P1 - it consumes about 10% of the capacities CPU resources. Fine if you proactively manage your tenant, but most companies don't have this much background CU to spare.

  • @juanpablorvvv
    @juanpablorvvv2 ай бұрын

    Include copilot for python notebooks and scripts. Seems like a “overfitting” demo, let’s hope it works as shown.

  • @kasyaci
    @kasyaci2 ай бұрын

    Am I the only one who sees an added value for DAX part but not the rest? I think, copilot should go more on Power Query side. It would add more value on that part, at least to my life as a developer. For now, I'm sticking with Chat GPT 4.

  • @LeeTen8
    @LeeTen82 ай бұрын

    So this is available in Premium?

  • @SamuelRoshan

    @SamuelRoshan

    2 ай бұрын

    No Fabric only

  • @emilat_laccd630
    @emilat_laccd6302 ай бұрын

    why the video resolution is so low? looks pretty blurry not for my old eyes ;)

  • @vishwasbandivdekar4746
    @vishwasbandivdekar47462 ай бұрын

    The resolution of the screen sharing is so bad. Please do something about it. Rest all seems fantastic.

  • @RoshanJhamca
    @RoshanJhamca2 ай бұрын

    Great, users , i think now company dont need PBI developers, in future

  • @AndyLeonard
    @AndyLeonard2 ай бұрын

    Impressive! :{>

  • @pranaysharma8694
    @pranaysharma86942 ай бұрын

    Copilot can't write measures, also it can't help improve an existing report. It is for very basic reporting.

  • @user-fy7bv1pb9n
    @user-fy7bv1pb9n2 ай бұрын

    So dramatic... YEEEES!!! 🤣

  • @AbhishekSharma-dn5us
    @AbhishekSharma-dn5us2 ай бұрын

    I guess No one would require a Power BI developer in future 😢

  • @skeletor4115
    @skeletor4115Ай бұрын

    2:15 "Beautiful DAX" ? ? ? ?

  • @AjEzqa
    @AjEzqa13 күн бұрын

    Wow! It’s like telling me you can’t use it because you are poor and don’t have a premium capacity. So miss out on it but here’s something that rich people have access to.

  • @kyleb350
    @kyleb350Ай бұрын

    Pretty cool, but not premium capacity money cool.

  • @milpatel83
    @milpatel83Ай бұрын

    Who would have thought so many people are interested in copilot.....

  • @wezzo111
    @wezzo1112 ай бұрын

    so nobody is critical here. I tried the report create tool with copilot, its all basic stuff and nothing mind blowing what i expect from a AI. if you ask copilot to change a visual or a current page it cant. Also if you ask to create a page for example with only line graph visuals it creates a page but also with other type of visuals. So it doesnt feel like real AI or it is very basic. Also what microsoft never tells in this kind of video's are the costs on the capacity. Glady copilot doesnt cost a lot but you have to use the online report create tool that one eats easily a P1/F64 capacity. If you work with more than 5 people at the same time longer than a hour it is on 100%. For now you dont miss a thing if you dont have premium capacity.

  • @imconfused1237

    @imconfused1237

    2 ай бұрын

    Exactly. Anyone who thinks this is amazing has genuinely never held an analytical role. I see datapoints suggested to be “insights” and yet, they’re nothing of the sort. It is the classic case of techies not having a clue as to the actual purpose of creating BI. I assessed Copilot for our Board. For us, it would’ve been a £1m uplift on the monthly operating cost. I reached out to our account lead at MS and they couldn’t even articulate simple ROI scenarios. That is really basic for an investment and they couldn’t do it. Anyone who knows MS - I’ve worked with them for over 20yrs - understands that they have a huge problem. All they’re currently doing is spitting out products with very undefined benefits, and it is really frustrating enterprise. They don’t like a “no” either; seem to think that they’ve gods gift and we will just buy any old rubbish. This sort of stuff is the latest gimmick and you can rest assured, it’ll be something else in 6mths time.

  • @NabranAboubacar
    @NabranAboubacar2 ай бұрын

    Thx guys. Please Microsoft, provide good mic to all your employees. Their sound is terrible each time.

  • @remek5758
    @remek575823 күн бұрын

    It's all fun & games untill your org turn off this feature because of security reasons xd Like idk why copilot gets so much hype, for most of the time you dont have perfect models that can work with this very well

  • @user-li4ro6jm6d
    @user-li4ro6jm6d12 күн бұрын

    i cant even sign into copilot because of verification smh

  • @amritutube
    @amritutube2 ай бұрын

    Why bother creating semantic model.. that should also be done by co pilot ... we should just give data and ask question .. very much like Thoughtspot

  • @SamuelRoshan
    @SamuelRoshan2 ай бұрын

    Nothing is on Public Preview unless you switch to a FABRIC Workspace or enable the 60 days Fabric Trail! Whats the point of showing all these fancy functionality to our users , and they fall in love with it , but do not have the budget to upgrade!? I dont understand why we need to be on Fabric if we are only going to be using Power BI and CoPilot. We dont need 95% of the offerings.. only Power BI.

  • @imconfused1237
    @imconfused12372 ай бұрын

    Microsoft has done a poor job of explaining the ROI. If anyone thinks that ‘matter of fact’ bullet points is a “narrative”, they haven’t worked with senior stakeholders. True insight comes in the ability to explain WHY a data point has increased or decreased. In my company, I sit on a board. We expect the Leads to robustly explain performance and that requires them to understand and own the data. If any of them turned up with this rubbish, believe me - they would be fired.

  • @SamuelRoshan

    @SamuelRoshan

    2 ай бұрын

    Smart Narrative and Power BI insights can tell you why something has Increased or decreased.

  • @molloarden8938

    @molloarden8938

    Ай бұрын

    that is the province of advanced stats where human human judgement governs selection of the analytical model--quasi exp designs, SEMs, etc--far from what's shown here.

  • @huutsch79
    @huutsch79Ай бұрын

    The price is more a joke

  • @elishmuel1976
    @elishmuel19762 ай бұрын

    In my experience, Copilot was a terrible POwer B expert, giving the wrong formulas, apologizing, then giving more wrong formulas. ChatGPT was MUCH BETTER acting as a Power BI expert. How could Microsoft screw that up?

  • @mrashton84

    @mrashton84

    2 ай бұрын

    This has been my experience so far as well. I will be curious to see how this evolves.

  • @vivmaha

    @vivmaha

    2 ай бұрын

    Thanks for the feedback. Would love if you can share examples so that we can improve.

  • @christimbers2006

    @christimbers2006

    2 ай бұрын

    Worse still of course, Co-Pilot is only available on paid for premium SKUs (Fabric or PowerBI)

  • @imconfused1237

    @imconfused1237

    2 ай бұрын

    @@vivmaha You don’t work for Microsoft. Go and get a job and you can stop pretending.

  • @molloarden8938
    @molloarden8938Ай бұрын

    wished she'd talk a bit faster....

  • @davidjones7144
    @davidjones71442 ай бұрын

    The magic was... MS never told us this was beeing forced in an update. I dont want it. Killed it. Thumbs down.

  • @dsswooshy
    @dsswooshy2 ай бұрын

    I'm going to be honest here. I'd rather go to KZread and find an actual human who explains how to write the code, and then me learn how to do it. All this AI stuff requires perfect data to make it work. My company has data that isn't perfect. AI just doesn't work too well to be perfectly honest.

  • @MrDenisben
    @MrDenisben2 ай бұрын

    Her voice is boring

  • @Fernando_Calero
    @Fernando_Calero2 ай бұрын

    Carly rocks! 💃 👩‍🎤 🌟

  • @nhatthuonghuynh9604
    @nhatthuonghuynh96042 ай бұрын

    i wish my data model could be that straight-forward to churn out all the insights and information 🥲

  • @user-gh8xp1pq1c
    @user-gh8xp1pq1c2 ай бұрын

    Is it correct that Copilot can only be used in combination with a prermium or F64 capacity, which costs minimum 5.000$ per month?

  • @ryanjohnson656

    @ryanjohnson656

    Ай бұрын

    Good question I’m struggling to get this to work and had seen this somewhere. Yet this video says anyone can use

Келесі