Пікірлер
@jayjfreedman
@jayjfreedman 3 сағат бұрын
watched a couple of videos, yours actually worked for me, the screen size was a little small to see, otherwise really appreciate you posting
@timothyvavra7680
@timothyvavra7680 7 күн бұрын
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?
@Seftehandle
@Seftehandle 8 күн бұрын
It would be nice to have written instructions in the description of the video.
@mohankumarch2140
@mohankumarch2140 18 күн бұрын
how to add users data to service (Voice clarity)
@EightBallInHeaven
@EightBallInHeaven 26 күн бұрын
Thanks for useful guide for dax!
@jmccanlies
@jmccanlies 27 күн бұрын
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-PowerBI
@Learn-PowerBI 26 күн бұрын
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.
@jaybeebee9288
@jaybeebee9288 Ай бұрын
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-PowerBI
@Learn-PowerBI Ай бұрын
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!
@jaybeebee9288
@jaybeebee9288 Ай бұрын
@@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 :)
@paulkelly5947
@paulkelly5947 Ай бұрын
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-PowerBI
@Learn-PowerBI Ай бұрын
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!
@JenMayB
@JenMayB 2 ай бұрын
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.
@JenMayB
@JenMayB 2 ай бұрын
Under upn, how do you have a role that can see everything?
@andrewwong4053
@andrewwong4053 5 ай бұрын
Brilliant tutorial. Thank you so much !
@wonnapee
@wonnapee 5 ай бұрын
man you gotta change your mic. It s killing the whole vid
@WilliamRockseo
@WilliamRockseo 6 ай бұрын
Wow... Thank you for the knowledge transfer
@andriamills7309
@andriamills7309 6 ай бұрын
The Targets Demo.CSV file is not available in the downloads files
@Datavers
@Datavers 6 ай бұрын
Please Use bettter Mic for consistnt Voice Quality
@SanjayMahato76435
@SanjayMahato76435 6 ай бұрын
There is not any meaning of such videos. Nothing is visible
@henrifanda4784
@henrifanda4784 6 ай бұрын
amazing function in new Power BI update
@NiftyBytes
@NiftyBytes 7 ай бұрын
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!!
@NiftyBytes
@NiftyBytes 7 ай бұрын
Sample file target_items.csv is NOT available in the folder
@flickhunter8900
@flickhunter8900 7 ай бұрын
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
@Learn-PowerBI 7 ай бұрын
On the stacked column visual, the "value" field is the "Y Axis" field. You should put your values into this "Y Axis" field.
@pabeader1941
@pabeader1941 7 ай бұрын
The free one does everything a small business needs. You make it sound like it's not very useful.
@alassanecoulibaly4424
@alassanecoulibaly4424 8 ай бұрын
Please can somebody give me the sample data. the link to download it do not work. Thank you in advance
@carralegend23
@carralegend23 8 ай бұрын
Thanks for sharing this insightful video. Keep up the good work :)
@l3ertuz362
@l3ertuz362 8 ай бұрын
too much talking!!!
@Nalaka-Wanniarachchi
@Nalaka-Wanniarachchi 8 ай бұрын
Good video,Since there is three levels of hierarchy in this example can we show all three levels with rankx?
@Learn-PowerBI
@Learn-PowerBI 8 ай бұрын
Yes - you can! This DAX method will work for any number of hierarchy levels you want to rank within a single measure.
@Nalaka-Wanniarachchi
@Nalaka-Wanniarachchi 8 ай бұрын
Good video,Isn't there a way to not use cross-filter assuming tables have relationships?
@Learn-PowerBI
@Learn-PowerBI 8 ай бұрын
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
@Nalaka-Wanniarachchi 8 ай бұрын
@@Learn-PowerBI I meant cross filter dax function.
@Learn-PowerBI
@Learn-PowerBI 8 ай бұрын
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
@hendriknieuwenhuizen4397 8 ай бұрын
The screen details are too small for a mobile phone. A real shame for such an important tutorial.
@MDCRITICA
@MDCRITICA 9 ай бұрын
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
@Learn-PowerBI 8 ай бұрын
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
@justindixon5999 9 ай бұрын
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.
@justindixon5999
@justindixon5999 9 ай бұрын
@@Learn-PowerBI keep up the great content!
@eladiohernandez6482
@eladiohernandez6482 9 ай бұрын
Amazing video. Thanks!
@jayxpea
@jayxpea 10 ай бұрын
This was very infomative. Well demonstrated on the what the new function can do. Much appreciated and thank you!!
@Learn-PowerBI
@Learn-PowerBI 10 ай бұрын
Thank you - Happy to hear it was helpful!
@user-cf2mv1ri6b
@user-cf2mv1ri6b 10 ай бұрын
Excellent video for beginners. Good demonstration.
@yagnralph
@yagnralph 10 ай бұрын
I want to know how to configure RLS in Power BI Embedded
@Learn-PowerBI
@Learn-PowerBI 10 ай бұрын
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!
@ashwinkumar5223
@ashwinkumar5223 10 ай бұрын
If possible can you make with increased font size to follow with you
@giancajaracadillo
@giancajaracadillo 11 ай бұрын
excelente amigo, podrías compartir la data para practicar por favor?
@hajimalangmallikar6523
@hajimalangmallikar6523 11 ай бұрын
IT WAS USEFUL BRO, PLEASE INCREASE THE FONT SIZE AND GIVE LINK FOR DATASET TO PRACTICE
@Learn-PowerBI
@Learn-PowerBI 11 ай бұрын
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
@jayxpea 11 ай бұрын
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
@Learn-PowerBI 11 ай бұрын
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
@jayxpea 11 ай бұрын
This was so easy to understand. Thanks so much!
@Learn-PowerBI
@Learn-PowerBI 11 ай бұрын
Thanks for the feedback - glad you found it helpful!
@jayxpea
@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
@Learn-PowerBI Жыл бұрын
Happy to hear you found a helpful tip in there!
@kapur.betzy2023
@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
@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
@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
@Learn-PowerBI
@Learn-PowerBI Жыл бұрын
Glad you found it helpful!
@QasimAli-gy3nb
@QasimAli-gy3nb Жыл бұрын
Brainchild of Melissa De Korte. Amazing work.
@QasimAli-gy3nb
@QasimAli-gy3nb Жыл бұрын
Can you do a short intro video, please.
@Learn-PowerBI
@Learn-PowerBI Жыл бұрын
Hey! Certainly - I plan on doing something like this once theres a bit more PBI content on the channel :) Hope you found the video helpful!