Video

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.

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!

@@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 :)

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!

On the stacked column visual, the "value" field is the "Y Axis" field. You should put your values into this "Y Axis" field.

Yes - you can! This DAX method will work for any number of hierarchy levels you want to rank within a single measure.

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!

@@Learn-PowerBI I meant cross filter dax function.

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.

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!

Glad to hear the video taught you something useful! Thank you :)

@@Learn-PowerBI keep up the great content!

Thank you - Happy to hear it was helpful!

Glad you found it helpful!

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!

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

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!

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.

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!

Thanks for the feedback - glad you found it helpful!

Happy to hear you found a helpful tip in there!

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 :)

Glad you found it helpful!

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!