Tag: Power BI

Change the Data Source TYPE of the Power BI Dynamically using Power Query Parameters

Posted on by Reza Rad

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

Power Query Function: Column Value Distribution in Power BI

Posted on by Reza Rad

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

Creating Column Values Distribution Report in Power BI Using Power Query

Posted on by Reza Rad

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

Drill Down and Up in Power BI Explained

Posted on by Reza Rad

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

Azure Map in Power BI with Layers: Part Three

Posted on by Leila Etaati

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

Azure Map in Power BI: Part Two

Posted on by Leila Etaati

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

Page-Level Security workaround in Power BI

Posted on by Reza Rad

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

Sync Slicers in Power BI

Posted on by Leila Etaati

In some of the reports with many pages, some of the slicers are common, and all pages need to have them. Moreover, in some data analysis approach, we may want to apply one slicer, not on-page, but in all other pages in our reports. In this scenario, we need to use the sync slicers option Read more about Sync Slicers in Power BI[…]

Power BI Bookmarks: Grouping

Posted on by Leila Etaati

Bookmarks are a way of storytelling, There are many examples of using Bookmark to show narrative storytelling check Reza Rad blog post on “Bookmarks and Buttons“. Imagine you created several bookmarks from different pages you have in the Power BI file. however, not all bookmarks are related to the same story. One related for example Read more about Power BI Bookmarks: Grouping[…]

Why data preparation and transformation? Why Power Query?

Posted on by Reza Rad

Does Power Query requires training or reading a book, or even reading an article? I get this question a lot from those who started Power BI not long ago. Many users think that Power Query is just the get data from the source, and that’s it. Considering the many data source connectors in the Power Read more about Why data preparation and transformation? Why Power Query?[…]