Very helpful, Glad if you could provide the sample dataset too !
@visheshvs90272 ай бұрын
Awesome
@JovanSakovic-y9i2 ай бұрын
legend! top notch tutorial, saved me hours of trying to comb through stale Power BI docs
@chrisowens61612 ай бұрын
great video, can we do the same with PowerBi pagenated reports as "parameters" in those reports are different.
@xXDUSC8XxАй бұрын
have you been able to figure out the paginated report issue?
@abimbolaolatoto66383 ай бұрын
The best power bi lecture. I learnt alot within a short periof
@mshparber4 ай бұрын
Nice, but if you want the data be realistic and have all kind ps of insights, chatGPT starts crashing
@jayjfreedman4 ай бұрын
watched a couple of videos, yours actually worked for me, the screen size was a little small to see, otherwise really appreciate you posting
@Learn-PowerBI4 ай бұрын
Love to hear the videos are helping! Getting ready to come back and start uploading more, hoping the quality is improved with better screen resolution or the videos so you can see the text better. Goodluck on your Power BI journey!
@timothyvavra76805 ай бұрын
Not a comment but a question. I have a hierarchy between vp, supervisor and user. If the vp goes into the pbi report, there filter will be applied and they would get all their supervisors and employees, if the supervisor logs in they would see all their employees and if the employee signs in they would only see the employee data. I have a table with all of the user ids and their related userprincipalname but I am not sure how to lookup and filter based on that hierarchy. There is a one to many relationship between vp and supervisor and between supervisor and employee. Each employee will only have one supervisor and one vp, and each supervisor will only have one vp. Is there a way to do this using the dynamic rls?
@Seftehandle5 ай бұрын
It would be nice to have written instructions in the description of the video.
@mohankumarch21405 ай бұрын
how to add users data to service (Voice clarity)
@EightBallInHeaven5 ай бұрын
Thanks for useful guide for dax!
@jmccanlies5 ай бұрын
Copilot landed me here! My search was "What is the best way to distribute a powerbi report so that it is read only?" and this video was the ONLY one included and allowed viewing from within copilot itself. I watched the video and it described exactly what I wanted to do - plus a lot more ways I can distribute it also. Nice job and I wanted you to know Microsoft AI is giving you some hits if you didn't know already.
@Learn-PowerBI5 ай бұрын
Woah! Thats super cool! Thanks for letting me know! :) Hopefully the video helped get you what you were looking for. That makes me want to create and post more videos if there are so few out there to help with these things. Thanks again for this comment, thats really cool to hear.
@jaybeebee92886 ай бұрын
Practically useless, all I can see is an arrow moving around some blurry shapes and objects, you sound competent but the video is so zoomed out everything's unclear.
@Learn-PowerBI6 ай бұрын
Sorry you didnt find the tutorial valuable! Were you able to try watching on full screen at the highest resolution? It should all be visible, it is slightly blurry (apologies! was still new to the whole recording thing) but it should be clear enough to follow along and see the text, values, and syntax. Hope this helps a bit and you're able to find a tutorial that works better for you! Goodluck on your Power BI adventure!
@jaybeebee92886 ай бұрын
@@Learn-PowerBI Hey, I appreciate the good spirited reply, I too will be a little kinder :) So, first I admit I'm watching on a 17" laptop, whereas you probably created on multimonitor so of course you can see everything, but I have set the resolution to 1080 HD, I still have to lean in and squint to read much. Possibly try watching your video yourself from another YT account. I would say in future when creating a presentation, to make a lot more use of the zoom PLUS what you do now, which is hovering your mouse to indicate what you're talking about. BTW I've created my first PBI project....embarassingly, a single visual answers the business question, so while it's informative and very insightful, it's not exactly command centre pretty :)
@paulkelly59476 ай бұрын
Thanks for the video. There is one question I have. Does this method allow the user to refresh the data or is there another process we must go through to ensure users have the current data?
@Learn-PowerBI6 ай бұрын
Glad you found it helpful! Users would be able to kick off a manual dataset refresh directly through the workspace - however, these users would require at least the Contributor role on the workspace. Another way users can be sure when the data in the reports was last refreshed would be to include a date/time the dataset was last refreshed within all of the reporting you published (I'll be getting back into creating PBI YT videos shortly and will make one on how to create this field and include it in your reports) or, if youre connecting to a data source that allows for a DirectQuery connection, you can set tables to DirectQuery and the reports data will always be live. This could/will negatively impact the load time of reports if the model/DAX are inefficient. Hope this helps!
@JenMayB7 ай бұрын
Also, how do you get your card values to update based log in? Mine show totals until they click on the role they can see.
@JenMayB7 ай бұрын
Under upn, how do you have a role that can see everything?
@andrewwong405310 ай бұрын
Brilliant tutorial. Thank you so much !
@wonnapee10 ай бұрын
man you gotta change your mic. It s killing the whole vid
@WilliamRockseo11 ай бұрын
Wow... Thank you for the knowledge transfer
@andriamills730911 ай бұрын
The Targets Demo.CSV file is not available in the downloads files
@Datavers11 ай бұрын
Please Use bettter Mic for consistnt Voice Quality
@SanjayMahato7643511 ай бұрын
There is not any meaning of such videos. Nothing is visible
@henrifanda478411 ай бұрын
amazing function in new Power BI update
@ByteChunx Жыл бұрын
Sample files are not consistent with the ones you are using, so the models could not be re-produced in practice. Thus, most stuff in Visualizations could not be followed practically. Otherwise this is a very good course and well detailed. MANY THANKS!!
@ByteChunx Жыл бұрын
Sample file target_items.csv is NOT available in the folder
@flickhunter8900 Жыл бұрын
When I add a stacked column charts. I get X axis and y axis but there is no "value" option. How to troubleshoot it
@Learn-PowerBI Жыл бұрын
On the stacked column visual, the "value" field is the "Y Axis" field. You should put your values into this "Y Axis" field.
@pabeader1941 Жыл бұрын
The free one does everything a small business needs. You make it sound like it's not very useful.
@alassanecoulibaly4424 Жыл бұрын
Please can somebody give me the sample data. the link to download it do not work. Thank you in advance
@carralegend23 Жыл бұрын
Thanks for sharing this insightful video. Keep up the good work :)
@l3ertuz362 Жыл бұрын
too much talking!!!
@Nalaka-Wanniarachchi Жыл бұрын
Good video,Since there is three levels of hierarchy in this example can we show all three levels with rankx?
@Learn-PowerBI Жыл бұрын
Yes - you can! This DAX method will work for any number of hierarchy levels you want to rank within a single measure.
@Nalaka-Wanniarachchi Жыл бұрын
Good video,Isn't there a way to not use cross-filter assuming tables have relationships?
@Learn-PowerBI Жыл бұрын
Cross-filtering does not limit data access at data source, whereas RLS does. So, if you simply need to have a report filtered down to various items, you should manage that filtering of the report directly through the reports filtering, visuals cross-filtering, and your measures, but if you need the data end-users have access to view to be restricted, this is where RLS comes into play. Hope this helps!
@Nalaka-Wanniarachchi Жыл бұрын
@@Learn-PowerBI I meant cross filter dax function.
@Learn-PowerBI Жыл бұрын
Ah, the CROSSFILTER() function would not be able to accomplish any RLS type solution. This function is used for overriding the default models relationship filter direction between the tables specified. For instance, you have a location lookup to your sales table (active one-to-many relationship) and for some reason you want your sales table to filter your lookup table for one of your measures, you could use CROSSFILTER() to adjust the active relationship in the model to change the relationship specified in the model to filter location lookup by the sales table. This function is a pretty niche DAX function that you likely won't be needing in a majority PBI projects. If you see yourself trying to use this function, there is likely an issue with your base model that might need to be adjusted to get the full model to function as intended.
@hendriknieuwenhuizen4397 Жыл бұрын
The screen details are too small for a mobile phone. A real shame for such an important tutorial.
@MDCRITICA Жыл бұрын
Always Like for beginners in U2. Just little feedback, I wish I could see the different blocks in the video timeline. To go straight where I want to go. Great Video, Thanks!
@Learn-PowerBI Жыл бұрын
Glad you found it helpful! Sorry about no chapters - I thought YT did those automatically based on the upload (still new to the whole YT thing!). I'll get the chapters added in ASAP, thank you for pointing out they arent there!
@justindixon5999 Жыл бұрын
This is great! Thank you so much, I was having trouble trying to share reports with people who did not have a power bi account.
@Learn-PowerBI Жыл бұрын
Glad to hear the video taught you something useful! Thank you :)
@justindixon5999 Жыл бұрын
@@Learn-PowerBI keep up the great content!
@eladiohernandez6482 Жыл бұрын
Amazing video. Thanks!
@jayxpea Жыл бұрын
This was very infomative. Well demonstrated on the what the new function can do. Much appreciated and thank you!!
@Learn-PowerBI Жыл бұрын
Thank you - Happy to hear it was helpful!
@SabithaBalasubramanian Жыл бұрын
Excellent video for beginners. Good demonstration.
@Learn-PowerBI Жыл бұрын
Glad you found it helpful!
@yagnralph Жыл бұрын
I want to know how to configure RLS in Power BI Embedded
@Learn-PowerBI Жыл бұрын
Hello - I'll work on getting a video for this published, wont be able to get it out for a weeks though, sorry! As a stop-gap or to get going on your own, here Microsofts explanation of how to set this up, learn.microsoft.com/en-us/power-bi/developer/embedded/cloud-rls. As a high level overview of how RLS in embedded reports work, see this explanation (not sure if this is helpful or not but hopefully it helps get you started!): - When a user accesses the embedded report, they are authenticated through your app's authentication process. - After authentication, your application will generate an embed token for the user. This embed token is generated through an API call to Power BI, and the information used to generate this token will typically include the user's identifier and the roles that apply to that user, this can include dynamic or static RLS rules that are covered in this course. This embed token is crucial as it dictates what data the user is allowed to see based on the RLS roles and rules defined in the Power BI model. - When the embedded report is accessed by the user, the Power BI service uses the information in the embed token to apply the RLS rules. The filtering based on RLS is performed on the Power BI service side, not in your application. The embedded report in your application will only show the data the user is allowed to see based on the RLS rules. Certainly a lot more in-depth than just RLS for report viewing directly within Power BI service, but totally possible to get setup. I'll work on getting a video out for this ASAP!
@wingnut293 ай бұрын
Same for Power Apps with Power BI Embedded. I am trying to get this work with Manger Hierarchy Security in a Power Apps application that has an embedded Power BI report
@ashwinkumar5223 Жыл бұрын
If possible can you make with increased font size to follow with you
@Learn-PowerBI Жыл бұрын
Sorry about the small size of the text in these first videos! I've started to record on a resolution thats a lot easier to see once uploaded - I'll be uploading more videos about Power Query and how to clean messy source data with all the text easier to read. Hopefully you were still able to follow along somewhat, even with the small text
@giancajaracadillo Жыл бұрын
excelente amigo, podrías compartir la data para practicar por favor?
@Learn-PowerBI Жыл бұрын
The data used is available for download through the course on learn-powerbi.com. If you join the "Getting Started with Power BI" free course, the 1st step in the course has a download with all the data files covered in the video. Hopefully this helps! Los datos utilizados están disponibles para descargar a través del curso en learn-powerbi.com. Si se une al curso gratuito "Introducción a Power BI", el primer paso del curso tiene una descarga con todos los archivos de datos cubiertos en el video. ¡Ojalá esto ayude!
@hajimalangmallikar6523 Жыл бұрын
IT WAS USEFUL BRO, PLEASE INCREASE THE FONT SIZE AND GIVE LINK FOR DATASET TO PRACTICE
@Learn-PowerBI Жыл бұрын
Of course - downloadable link to the demo file has been added to the videos description. Thank you for the feedback on the font size!! I will increase the font size in all my videos going forward.
@jayxpea Жыл бұрын
Hi mate, just want to say great videos. I've been watching consistently. Noticed you have two facts tables in his dataset. Would love you to see a video on how it setup relationship wise, are they both linked, drawbacks, etc
@Learn-PowerBI Жыл бұрын
I've got a walkthrough on relationships on the channel - was one of the first videos, you can check that one out, "Understanding Power BI Relationships - How to Create Them, What They do, and Walkthrough Tutorial"! And if you want to get more in-depth with it, I've got a lot more content around relationships in the free course at learn-powerbi.com. If you've still got some questions, happy to get another video out there to go into more of the specifics youre looking for!
@jayxpea Жыл бұрын
This was so easy to understand. Thanks so much!
@Learn-PowerBI Жыл бұрын
Thanks for the feedback - glad you found it helpful!
@jayxpea Жыл бұрын
Wow learnt something new even though you didn’t mention it at all. Creating a new measure from an existing. I usually copy the measure formula, go to add new measure then paste it down, rename, reedit etc I saw you edit in the existing measure and renamed it and do the same thing. So much easier and faster 👍👍👍👍
@Learn-PowerBI Жыл бұрын
Happy to hear you found a helpful tip in there!
@kapur.betzy2023 Жыл бұрын
Can you create a simple beginner's video on how to create TopN along with Others category to show the respective Sales using DAX please
@Learn-PowerBI Жыл бұрын
Certainly - I'll get a video on TopN published in the next week or so! Thanks for the request, hope you found this one helpful :)
@jayxpea Жыл бұрын
Thanks for this. I've been self learning for a while and found these very good to reinforce what I already know. Got yourself a new subscriber