Another aspect of sharing is the security of the dataset. Enabling different roles and giving users access to different levels of data is called Row Level Security. This post explains the details of this security method and how to configure it in Power BI Desktop. Row Level Security enables you to apply security to roles Read more about Row Level Security in Power BI Desktop[…]
Organizing events always start with session selection and finally creates a schedule on it. As I was busy always with community activities, I am using sessionize website a lot, this website is free of charge for free and nonprofit conferences, but for the paid conference, you need to pay as you using it ( fair Read more about Template Power BI File for Sessionize.com[…]
Because Power BI is an easy-to-start platform and you don’t need an extensive learning curve to get started with Power BI Desktop, we often see some bad practices in the implementation of Power BI reports. In this article and video, I explained the top five mistakes that I see happen a lot in building Power Read more about Top Five Mistakes to Avoid When Developing Power BI Reports[…]
I have previously written articles about how you can write a measure in DAX that helps with TOP N filtering. However, you may not need that calculation for many situations. If all you want is just simply to get the top 10 customers based on the sales amount, or bottom 5 products, etc, then you Read more about TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter[…]
If you have too many items in a slicer, such as the list of customer names, or product names, then finding one amongst the list takes time, unless you enable the search. Fortunately, the search is there for you, you just need to enable it, In this very short article and video, I’ll explain where Read more about Search Bar in Power BI Slicer[…]
Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. https://charticulator.com/gallery/co2_emission_ranking.html In this example, I am using Carbon dioxide emission data for Read more about Ranking Chart in power BI Desktop Using Charticulator[…]
If you want to develop Power BI reports, you’ll need the Power BI Desktop application. However, Power BI Desktop application comes in two ways; Download it separately and install it on your Windows machine, or Get it from Microsoft Store as an App. The question that I often get is; What is the difference? which Read more about Power BI Desktop Download or Microsoft Store App? Which One?[…]
I am excited about this blog post, this is based on the New service in Cognitive Service name “Anomaly Detection” which is now in Preview. I recorded a video about how it works in cognitive service https://youtu.be/7ZOtZDbn6gM. However, I am going to talk about how to use it in Power BI. In this post first, a Read more about Time Series Anomaly Detection in Power BI using Cognitive Service and Power Query[…]
There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in Read more about Overview of Available AI and ML capabilities in Power BI[…]
One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]