Latest Power BI and AI articles from RADACAD team
I have written a blog article about the date dimension, and also one about the time dimension. However, I got some questions in the comments about how they will be used together in a data model. In this article, I’ll explain that. Date Dimension The date dimension or calendar dimension is one of the most Read more about How to Use Time and Date Dimensions in a Power BI Model[…]
I have written some articles on the RLS topic already. Through my consulting experience, however, I get the feeling that many people can’t easily move from static RLS to dynamic. If you know what are things you need to have the dynamic RLS implemented, it makes the whole process simple. So this is what I Read more about What Do You Need to Implement Dynamic Row-Level Security in Power BI?[…]
In my previous article/video, I explained how you can hide sensitive data from the user’s view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to Read more about Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security[…]
I wrote several row-level security articles so far, and a book. I explained how to restrict access to the data using row-level security approaches. However, one of the questions I got recently is this: “I want users to see one another’s sales information, but not to see who others are! How can I do that Read more about Show the information but not the details: Power BI Data Masking[…]
Another service to Microsoft Cognitive Text Analytics API is Text Analytics API, which is about Entity Linking, and Named Entity Recognition (NER). Entity Linking: Entity Linking able to identify the disambiguate the identity of an entity found in the text (for example, determining whether an occurrence of the word Mars refers to the planet, or Read more about Text Entity Extraction in Power BI, Text Analytics Service[…]
If you have been using dataflows, and you have the return value of a query as something which is not in the form of a table, such as a record, list, or value. then you have seen that the dataflow automatically converts them all to tables. There is an explanation about it, and a method Read more about Working with Records, Lists, and Values in Power BI Dataflows[…]
I have previously written a blog post about what the ALL function in Power BI is, and how it helps in working with filters in your report. However, still I get many students confused about how to use this function, which parameter to pass to it. This blog post is explaining that in detail. Why Read more about How to Use ALL in a DAX Expression in Power BI[…]
In the last post, I have explained how to work with Q&A visual . There is a way to define terms for the Q&N visual. There are two main terms Adjective Define an explanation for a column using a Measure. We able to define a measure as adjective for each columns of data. Columns Define Read more about Q&A Visual – Define an Adjective for a Column[…]
There are a couple of useful actions that help a lot in cleaning data; removing digits, or keeping digits and removing everything else. In this short blog article, I’ll explain a simple method to do that using Power Query. Sample Data My sample data table looks like this: Removing Digits I can easily get rid Read more about Remove Digits or Keep them in Power BI Using Power Query[…]
If you have used the relative date slicer and you are not living at a timezone close to UTC, then you have seen that the Power BI Date slicer is not much of a use, because you have to still adjust it with your local time zone. I have previously written a couple of articles Read more about Relative Date Slicer for Your Local Time Zone in Power BI[…]