Latest Power BI and AI articles from RADACAD team
ScatterRViz ScatterRViz is a custom visual for showing three variables in one chart. There is a possibility to zoom in and zoom out on the chart. This custom visual needs 1- X-axis as the first variable 2- Y-axis as the second variable 3- Color (categorize variable) for the third axis To use this chart, you Read more about Scatter RViz: Power BI R Custom Visual[…]
There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through Read more about List.Accumulate Hidden Gem of Power Query List Functions in Power BI[…]
In the last Part, I have talked about the main concepts behind the Decision Tree. In this post, I will show how to use decision tree component in Power BI with the aim of Predictive analysis in the report. in next post, I will explain how to fetch the data in Power Query to get a dynamic Read more about Decision Tree: Power BI- Part 2[…]
I’m excited to share the news with you that we have added a new feature in Power BI Helper; Expression Tree. Expression Tree will expand the tree of expression for a Measure or calculated column, you can see what other measures are used to create this expression, and where other measures, calculated columns, or even Read more about Expression Dependency Tree: New Feature of Power BI Helper[…]
A decision tree is one of the main approaches to machine learning. it is a really powerful tool for the aim of Prediction Descriptive analysis and feature selection In this post, I am going to show how decision tree works. In the future posts, I will show you some of the main algorithms for decision tree Read more about Decision Tree: Concepts- Part 1[…]
In previous posts, I covered some methods of Dynamic Row Level Security including Row Level Security user based, With Manager Level Access, and also with User and Profiles as a many to many relationships. In this post, I’m going to cover another common scenario for row level security; Organizational hierarchy for security. Through organizational hierarchy Read more about Dynamic Row Level Security with Organizational Hierarchy Power BI[…]
The Dynamic RLS topic is getting a good response in my blog post, so I intend to write about other types of scenarios that a security would be required. In this post, we are going to look at another type of security which deals with users and their profiles. Sometimes you have a user part Read more about Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship[…]
I have written while ago, about how to implement a dynamic row level security in Power BI. This post is an addition to that post. I’ve had a lot of inquiries that; “What If I want users to see their own data, and the Manager to see everything?”, or “How to add Manager or Director Read more about Dynamic Row Level Security with Manager Level Access in Power BI[…]
It’s been a while since the last post about Power BI REST API. I have written previously about how to get the REST API, and use it in your application, how the authentication works, and things such as embedding content, and data source management. In this post, I’m going to explain one of the functionalities Read more about Integrate Power BI Into Your Application: Part 6 – Real-time Streaming and Push Data[…]
PASS Summit 2017 Keynote in live now. Leila and I are sitting in bloggers table here, and will blog from here all new announcement through this post. Please Hit Refresh! Here we are at blogger’s table: Azure SQL Database and Machine Learning on a massive data set, demoed; Super fast loading 1.4 millions of records Read more about New Power BI and Analytics Features in PASS Summit 2017 Keynote – Live (Hit Refresh)[…]