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