3 Ways to handle BLANKs in Power BI!
7:09
Пікірлер
@satyajit015
@satyajit015 Күн бұрын
awesome video with a great detailing. Thanks a lot for explaining.
@gautambhandare8164
@gautambhandare8164 11 күн бұрын
Trust me even 10 year old won't understand this.
@FranciscoGarofalo-mb3ud
@FranciscoGarofalo-mb3ud 12 күн бұрын
nice video
@DataMozart
@DataMozart 10 күн бұрын
Thank you!
@pratikfutane8131
@pratikfutane8131 19 күн бұрын
Hi Nikola This is awesome. I have a query through in the implementation part. Since, the fields do not exist in the model (As per the error description in PBI Desktop with OLS applied) for a specific role, the visuals break. This means, the report author has to create another version of the report without using the fields included in OLS (To provide a seamless experience avoiding visual breakage error). Is my understanding correct ? Or there is a way to achieve this with a single copy of report supporting different roles ? (As in case of RLS) Please share some light. Many Thanks. Pratik
@loisiling5782
@loisiling5782 20 күн бұрын
Thank you so much!!!! Its such a good explanation!
@DataMozart
@DataMozart 19 күн бұрын
Glad it was helpful!
@edwardhicks630
@edwardhicks630 27 күн бұрын
Incredible summary, thank you!!
@DataMozart
@DataMozart 27 күн бұрын
Glad you liked it!
@MR-gw1hh
@MR-gw1hh Ай бұрын
Great explanation! Thank you
@DataMozart
@DataMozart 29 күн бұрын
Glad it was helpful!
@sazdean7233
@sazdean7233 Ай бұрын
DP500 will be discontinued, right?
@DataMozart
@DataMozart Ай бұрын
Yes, it will be retired by the end of April 2024
@vivekbusi5794
@vivekbusi5794 Ай бұрын
Wow very detail explanation
@DataMozart
@DataMozart Ай бұрын
Glad you liked it
@alexdenhaan5383
@alexdenhaan5383 Ай бұрын
Thank you for this clear explanation!!!
@DataMozart
@DataMozart Ай бұрын
Glad it was helpful!
@venukumargadiparthy8233
@venukumargadiparthy8233 Ай бұрын
Can you also please create a video on avro and orc file format?
@DataMozart
@DataMozart Ай бұрын
It's on my to-do list
@ahmettek315
@ahmettek315 2 ай бұрын
You didn't really explain it to a 5 year old. I am older than that, have experience with databases including low level storage, have a proven IQ level over the average but I am still at a lost after your video. So what does a parquet file look like physically? How do you create a parquet file? Answers to such questions are missing.
@DataMozart
@DataMozart Ай бұрын
Really sorry that you didn't find the video useful:(
@andreiberes9442
@andreiberes9442 Ай бұрын
proven IQ level over average =)))))
@marijakiran
@marijakiran 2 ай бұрын
This is fire! Thank you so much!
@DataMozart
@DataMozart 2 ай бұрын
Glad you like it!
@mannykhan7752
@mannykhan7752 2 ай бұрын
I just passed the DP-600 exam.
@DataMozart
@DataMozart 2 ай бұрын
Woohoo, congrats!
@nemmanja0289
@nemmanja0289 2 ай бұрын
great detailed explanation in short time, well done!
@DataMozart
@DataMozart 2 ай бұрын
Hvala Nemanja!
@Milhouse77BS
@Milhouse77BS 2 ай бұрын
Good short video. Thanks.
@DataMozart
@DataMozart 2 ай бұрын
Cheers Donald, glad you liked it!
@pradyumnakumaragasthyaraju8474
@pradyumnakumaragasthyaraju8474 2 ай бұрын
great video!
@DataMozart
@DataMozart 2 ай бұрын
Glad you enjoyed it
@MoonShine-bs6cl
@MoonShine-bs6cl 2 ай бұрын
Hi please suggest can i import 3-5 million records into power bi desktop from sql server... Is this possible for pro users. Thanks in advance
@DataMozart
@DataMozart 2 ай бұрын
Hi, it depends how many columns you have, their cardinality, etc. But, in most cases, yes, 3-5 million rows can be easily imported in Power BI.
@kizzashadrackyawe9646
@kizzashadrackyawe9646 2 ай бұрын
Great explanations! Thank you!
@DataMozart
@DataMozart 2 ай бұрын
You're very welcome!
@agustinluengo3323
@agustinluengo3323 2 ай бұрын
It was exactly the video that I was looking for, thank you!
@DataMozart
@DataMozart 2 ай бұрын
Thanks, I'm happy to hear that!
@AnjaliSharma-up2qs
@AnjaliSharma-up2qs 3 ай бұрын
This was cool .Thanks for sharing !
@DataMozart
@DataMozart 3 ай бұрын
Glad you enjoyed it
@PowerBIPark
@PowerBIPark 3 ай бұрын
Great stuff as always :)
@DataMozart
@DataMozart 3 ай бұрын
Thanks my friend!
@getsetgoo3334
@getsetgoo3334 3 ай бұрын
excellent info, thanks for sharing
@DataMozart
@DataMozart 3 ай бұрын
Glad it was helpful!
@sophiehan6121
@sophiehan6121 3 ай бұрын
awesome video, the best video explaining parquet file!
@DataMozart
@DataMozart 3 ай бұрын
Glad it was helpful!
@reach2puneeths
@reach2puneeths 3 ай бұрын
Can we create shortcut to Oracle database from fabric?
@DataMozart
@DataMozart 3 ай бұрын
No, at this moment it's still not available.
@reach2puneeths
@reach2puneeths 3 ай бұрын
Thanks for quick response
@Fernando_Calero
@Fernando_Calero 3 ай бұрын
Dark ages of PBI 👊 Great video Nikola, thanks for sharing! I do believe Field Parameters help end users a lot in their analysis and understanding of the data while keeping the report pages cleaner. Cheers
@DataMozart
@DataMozart 3 ай бұрын
Cheers Fernando, couldn't agree more with you about Field parameters👍
@WhisperingDeath
@WhisperingDeath 3 ай бұрын
"it takes a long time to make a story short" With so many hour-long techtube vids I appreciate how clear and concise you explained this topic!
@DataMozart
@DataMozart 3 ай бұрын
Thank you, I'm glad to hear that!
@avocadoarmadillo7031
@avocadoarmadillo7031 3 ай бұрын
Very helpful! I need to start making better use of incremental refresh, I've been neglecting it!!
@DataMozart
@DataMozart 3 ай бұрын
Glad it was helpful! Yes, IR is very important optimization feature!
@VictorHugo-bd3bf
@VictorHugo-bd3bf 4 ай бұрын
Thank you, Nikola. That is a very nice explanation, as usual.
@DataMozart
@DataMozart 4 ай бұрын
My pleasure! Glad that you liked it👍
@aleksandarboshevski
@aleksandarboshevski 4 ай бұрын
хахах ме изнасмеа со ова poor
@DataMozart
@DataMozart 4 ай бұрын
😀😀😀
@martinbubenheimer6289
@martinbubenheimer6289 4 ай бұрын
Hi Nicola, thank you for referring to my question 🙂 Greate start into live-streaming!
@DataMozart
@DataMozart 4 ай бұрын
Thank YOU for the great question!
@xianminxu8278
@xianminxu8278 4 ай бұрын
well explained
@DataMozart
@DataMozart 4 ай бұрын
Thank you, I'm glad if it helps!
@idhukaful
@idhukaful 4 ай бұрын
Can you share the link for DP600 exam as I was not present
@DataMozart
@DataMozart 4 ай бұрын
Sure, there you go: learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/
@jamesmcewan
@jamesmcewan 4 ай бұрын
good summary! well done 😉
@DataMozart
@DataMozart 4 ай бұрын
Thanks! 😃
@dimitrigbo823
@dimitrigbo823 4 ай бұрын
Excellent video... Big thanks!!!
@DataMozart
@DataMozart 4 ай бұрын
You are welcome! I'm glad you liked it👍
@user-ws7ey8pq6j
@user-ws7ey8pq6j 4 ай бұрын
great video! One question: how can we use powerBI desktop to work with Direct Lake? Currently it is not allowed, but are there any workarounds to it? Lets say I have an existing report based on ADLS Gen2. If I do the shortcut to One Lake and use SQL endpoint to replicate it and publish it with Import mode, can it be switched to use direct lake instead? Or do I have to re-create measures, data model, visuals etc in powerBI service from scratch in order to use Direct lake connection? Thanks
@DataMozart
@DataMozart 3 ай бұрын
Hi. As far as I know, Direct Lake is not working (yet) with Power BI Desktop. Hm, I'm not sure that the workaround you mentioned could work, because I believe you can't switch from import to Direct Lake. Cheers!
@dishantkukreja5899
@dishantkukreja5899 4 ай бұрын
Great Video, Thankyou!
@DataMozart
@DataMozart 4 ай бұрын
You're welcome! Happy to hear that you like it!
@roshankumargupta46
@roshankumargupta46 4 ай бұрын
Very apt!
@DataMozart
@DataMozart 4 ай бұрын
Thanks!
@drivetrainerYT
@drivetrainerYT 5 ай бұрын
Very thought-inducive, was listening in the background and had to check if subscribed already. Thank you
@DataMozart
@DataMozart 5 ай бұрын
Cheers, thanks!
@Nalaka-Wanniarachchi
@Nalaka-Wanniarachchi 5 ай бұрын
Very nice ,nikola !!!
@DataMozart
@DataMozart 5 ай бұрын
Thanks mate👍
@ashwin147
@ashwin147 5 ай бұрын
Good content for PowerBI incremental refresh
@DataMozart
@DataMozart 5 ай бұрын
Thanks!
@tommartens3953
@tommartens3953 5 ай бұрын
Hey #PowerBI and #MicrosoftFabric friends, I consider this video one of the best introductions to the "world" of incremental refresh! 👏 Nevertheless, here are some additional thoughts: - separate your data from the content (your data visualizations), because whenever you publish the data pbix to the Power BI Service your partitions will "reset". - prepare (meaning) train the initial load because your data is growing over time. I consider not training the initial load to be similar to Schroedingers backup, without a restore you do not know if the backup was successful - also, it is likely that you are already backed by a Premium capacity, if not take this into account (or Premium Per User licensing), the reason behind this - you can leverage the XMLA endpoint to update your semantic model with new measures without "resetting" the partitions
@DataMozart
@DataMozart 5 ай бұрын
These are all fantastic suggestions! Thank you very much, my friend!
@devinpikafire
@devinpikafire 5 ай бұрын
Very cool, this is extremely helpful. Well explained. Thank you
@DataMozart
@DataMozart 5 ай бұрын
Thanks, glad to hear that!
@carloscantu75
@carloscantu75 5 ай бұрын
Great content, thanks for sharing! Another benefit of using explicit measures is that you avoid issues when using implicit measures with Analyze in Excel. I believe some of these limitations have been removed when using Excel web, but as far as I know they are prevalent when using Excel app.
@carloscantu75
@carloscantu75 5 ай бұрын
Great content, thanks for sharing!
@DataMozart
@DataMozart 5 ай бұрын
My pleasure!
@kevinruckstuhl2378
@kevinruckstuhl2378 6 ай бұрын
Any good ways to identify memory usage during a refresh of a semantic model on the service? I'm currently trying to identify if a calculated column is causing memory issues e.g the dataset uses 1gb of memory before refresh and failed because it needed 24gb of memory.
@DataMozart
@DataMozart 5 ай бұрын
Hi Kevin, I'd suggest to check this blog post from Chris Webb and see if it helps: blog.crossjoin.co.uk/2023/04/30/measuring-memory-and-cpu-usage-in-power-bi-during-dataset-refresh/
@pedja2518
@pedja2518 6 ай бұрын
Hi Nikola, thank you for the useful video. One thing that bothers me 😊, why is Microsoft parted away with Credly? Current user experience related to the exams is very bad compared with Credly time. I think most of the people that take Microsoft exams will agree with me. Thank you and keep going,...
@DataMozart
@DataMozart 6 ай бұрын
Oh, I really don't have that information about Credly:(
@VictorHugo-bd3bf
@VictorHugo-bd3bf 6 ай бұрын
Thanks, Nikola; it is very useful; waiting for your great content.
@DataMozart
@DataMozart 6 ай бұрын
Cheers mate! Stay tuned, I'll start sharing learning resources very soon
@Nalaka-Wanniarachchi
@Nalaka-Wanniarachchi 6 ай бұрын
Nice side by side comparison !!
@DataMozart
@DataMozart 6 ай бұрын
Thanks ✌️
@romantesolkin7606
@romantesolkin7606 6 ай бұрын
great content and perfect timing, just wanted to do comparison and here is your video!
@DataMozart
@DataMozart 6 ай бұрын
Perfect!