RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship

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[…]

Dynamic Row Level Security with Manager Level Access in Power BI

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[…]

Integrate Power BI Into Your Application: Part 6 – Real-time Streaming and Push Data

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[…]

New Power BI and Analytics Features in PASS Summit 2017 Keynote – Live (Hit Refresh)

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)[…]

Azure ML workbench-Data Wrangling -Part 3

In the last posts, I have explained how to install Azure ML workbench and how to run a sample and check the accuracy. In this post, I am going to show how to do data wrangling using Azure ML workbench. Just click on the left menu, on the database icon. There are 2 separate groups Read more about Azure ML workbench-Data Wrangling -Part 3[…]

Azure ML workbench-Run Model-Part 2

In the last post, I have shown how to install the Azure ML workbench. Also, I have shown an example of classification problem with iris data how to load it and run it I run the code on the local computer. as you can see in the below picture, the physical place is “local”, there is Read more about Azure ML workbench-Run Model-Part 2[…]

Measure vs Calculated Column: The Mysterious Question? Not!

Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Column? What situation should we use each of these? and on the other hand, what is the difference of creating column here, Read more about Measure vs Calculated Column: The Mysterious Question? Not![…]

Searching a Field or Table in Power BI Visualization: Power BI Helper

Last week, we announced the very first version of Power BI Helper. Power BI Helper is a tool that helps clean up a Power BI solution. This week we have an updated version with a new interesting feature: Searching for a Field or Table in all visualizations in the PBIX file. The additional feature is helpful for further Read more about Searching a Field or Table in Power BI Visualization: Power BI Helper[…]

Azure ML workbench- Installation-Part 1

In Microsoft ignite 2017, Azure ML team announce new on-premises tools for doing machine learning. this tools much more comprehensive as it provides 1- a workspace helps data wrangling 2- Data Visualization 3-Easy to deploy 4-Support Python codes in this post and next posts, I will share my experiment with working this tools. first I got Read more about Azure ML workbench- Installation-Part 1[…]

Time series Series with Power BI- Forecast with Arima-Part 12

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle the seasonality parameters. in the last example for the age of death of the England king, Read more about Time series Series with Power BI- Forecast with Arima-Part 12[…]