Latest Power BI and AI articles from RADACAD team
About the book; Quick Intro from Author Azure Machine learning has been introduced in 2014. By seeing a demo in the SQL PASS Summit, I get interested in this product. From that time, I start to work with and demonstrating in different conferences. After a while, I start to write some weblog post about it. Read more about Book: Azure Machine Learning Studio: An Unleashed Guide[…]
One of the most common transformations in Power Query is the Remove Duplicates. This transformation is used in many scenarios, one of the examples, is to create a dimension table with unique IDs in it, so can be used as the source of a one to many relationships to fact tables in the relationship diagram Read more about Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution![…]
In previous posts, I have explained how to create a machine learning scenario using Azure ML components. One of the main advantages of using Azure ML is the ability to create a web service from it. That means the created model can be used in other services via an API URL and Password. In this post, I will show Read more about Azure ML Part 10, Create Web service from Models[…]
I have given many presentations and talks about Data Visualization, and still, I am amazed by how many visualizations I see which is not following the basic rules. In this article, I want to focus on table visual. A table is a visual that most of us are using it on many occasions, in fact, Read more about Show Me the Biggest Number! Conditional Formatting in Power BI[…]
In previous articles, I explained what is the Dataflow and where to use it, I also explained how to create a dataflow, and what is the common data model. In this article, I’m explaining one of the differences between Dataflow and the Power Query in Power BI Desktop, which is Linked Entities and Computed Entities. Read more about Linked Entities and Computed Entities; Dataflows in Power BI Part 4[…]
I have written some articles about advanced use cases of time intelligence but never wrote about it for beginners. as the time intelligence is an important part of many BI solutions, I decided to write about it from the beginning. In this article, first I explain what time intelligence is, and what are the requirements Read more about Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date[…]
Workspace version 2 has been available in Power BI Service for more than 6 months now. The new version introduced in August 2018, however, still many people don’t know what it is, and what is the difference of that with the old version, and the most important question: Should you create the new workspace in Read more about Workspace V2 of Power BI: What Are Advantages Vs Old Version?[…]
If you have used the drill down/up feature in Power BI, you know that it is a very powerful feature for exploring the data, you can expand a hierarchy to the next level, and go back. However, there is a little trick that can make your hierarchy exploration much better. Let’s check it out in this Read more about Better Drill Down Experience with Power BI[…]
You have published your Power BI report and want to share it with others. Now you see that you can share it through basic sharing, workspaces, Apps, publishing to web, Power BI embedded, and SharePoint online. The wide range of this variety of methods for sharing makes it confusing to choose the suitable method. I Read more about Power BI Sharing Methods Comparison – All in One Review[…]
These days, Dataflow (Power Query in Power BI Service) is a new feature that has been released. according to[1]: Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. If you want to know more about dataflow see [1] There is a new feature in dataflow that Read more about AI in Dataflow, Power BI webservice, Cognitive Service -Part1[…]