Latest Power BI and AI articles from RADACAD team
Recently Leila and I published a series of two books under the name of The Definitive Guide to Power Query in Power BI and Excel. Both books are now available in ebook and paperback format on Amazon and Google Play Books. In this blog, I’ll explain some details about the book, the agenda, and who Read more about Book Overview: The Definitive Guide to Power Query in Power BI and Excel[…]
About a couple of years ago, I wrote two articles about what is association rules and how we can have them in Power BI.In this post, I am going to put some more enhancements and show you how with data that is not cleaned how you can create Market Basket Analysis. these enhancements are about Read more about Market Basket Analysis in R Part 3[…]
I have written a blog article and explained how Power Query parameters can be used to change the data source in Power BI. Another useful scenario of it is actually to change even the data source itself. For example, you may have two data sources with exactly the same data structure (columns), but different data. Read more about Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters[…]
If you have a table and want to create a report of column value distribution of it in Power BI, This function helps you achieve it. I have explained previously in another blog and video, how to do this process step by step. In this article, I’ll share the code for a custom function that Read more about Power Query Function: Column Value Distribution in Power BI[…]
I have written about profiling data and the importance of it in Power Query, I also explained how the profiling data can be prepared to create a report in Power BI for the user to understand the data better. And I explained how the error count of that can be added to the report. Another Read more about Creating Column Values Distribution Report in Power BI Using Power Query[…]
Power BI works with hierarchies very easily, and there are buttons to drill down and up. However, sometimes, these buttons are confusing for the users. It is essential to know what each drill down/up option is and how it works, not just for developers but also for the end-users. In this blog and video, I’ll Read more about Drill Down and Up in Power BI Explained[…]
In the last two posts, I have explained how to access Azure Map and create bubble charts and Bar charts with other available settings. check the first Post from here and the second one from here. In this blog, I am going to talk about different layers we can have on top of the map. Read more about Azure Map in Power BI with Layers: Part Three[…]
In the last post, an introduction to Azure Map was presented. Azure Map has considerations and limitations as below( that may resolve later as now is in preview) You can use it in Power BI Desktop, Power BI Service, and mobile application But, not available Power BI publish to the web, Embedded and service embedding. Read more about Azure Map in Power BI: Part Two[…]
Reza rad already wrote some articles about Map visuals in Power BI such as ArcGIS, Shape Map, and Filled Map. In this blog post, I am going to talk about Azure Map Visual in Power BI. a definition from Microsoft website: “The Azure Maps visual for Power BI provides a rich set of data visualizations Read more about What is Azure Map in Power BI: Part One[…]
If you want to control the access to the Power BI report pages (or tabs) in a way that some users see some pages, and some others see other pages, we need something called page-level security. However, Power BI, as of today, doesn’t support visual-level or page-level security. There is a workaround to do it. Read more about Page-Level Security workaround in Power BI[…]