PowerBI is a business intelligence platform from Microsoft that enables users to analyze data and create interactive visualizations. It provides powerful tools for data exploration, analysis, and reporting. With PowerBI, users can quickly gain insights into their data by creating interactive dashboards, reports, and visuals.
This walk-through and resource list will provide an introduction of Power BI’s Object-Level Security (OLS) and when combined with Row-Level security (RLS), you can secure and hide specific metrics, measures, tables, or columns from report viewers when using Roles.
Being a Power BI enthusiast, I always find DAX a challenge but have found success by keeping to a couple of simple tricks. In this Power BI Tutorial, we review my DAX development workflow through an example case where we will use Power BI Desktop to create a KPI measure
I was looking for inspiration and some new ideas for dashboards. What better way than finding inspiring examples of BI solutions from others. The following are some of the go-to links that I am certain you can find useful.
Power BI gives you the ability to use a wide variety of data sources in your data visualization project. This walkthrough shows you how to access files in a Azure Data Lake and import them into a Power BI data models.
Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table. A working Live Interactive Power BI Sample is attached at the bottom of this post.
It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.
