Where is the Format visual option in the new Power BI Desktop? There is a simple answer to this question, which I explained in this blog and video. This change applied from March 2023 version of Power BI Desktop, and by the time you read this article, it might be at general availability and the Read more about FORMAT Visual in the New Power BI Desktop[…]
Power BI is more than Power BI Desktop. It is a combination of some components. Learning about these components and their role in the solution is important before any further steps. It is impossible to talk about architecture when you don’t know about Power Query or Power BI Service. Each component plays an important part Read more about Power BI Components[…]
Another aspect of sharing is the security of the dataset. Enabling different roles and giving users access to different levels of data is called Row Level Security. This post explains the details of this security method and how to configure it in Power BI Desktop. Row Level Security enables you to apply security to roles Read more about Row Level Security in Power BI Desktop[…]
There are different methods to use row-level security in Power BI; You can set up Row Level Security in Power BI itself or through a live connection from a data source such as SSAS Tabular. However, row-level security defined in the ways mentioned in the articles above isn’t dynamic. By dynamic row-level security, I mean Read more about Dynamic Row Level Security with Power BI Made Simple[…]
Power BI supports the security of the data at the dataset level. This security means everyone can see the data they are authorized to see. There are different levels of that in Power BI, including Row-Level Security, Column-Level Security, and Object-Level Security. All these help Power BI Developers create one dataset but give users different Read more about Data-Level Security in Power BI[…]
In any software application, the need for multiple environments is essential. Separating the user’s environment from the developer’s environment comes with many benefits. Power BI is not an exception in such scenarios. Having separate environments for different types of users can be helpful in many aspects. I’ll explain how Power BI handles this using Deployment Read more about Deployment Pipelines in Power BI; How the Software Development Lifecycle Works?[…]
Governance is an important aspect of every application and system in organizations. A Power BI solution architecture needs good rules and processes set up for governance to ensure the content is trustworthy. In Power BI, the content can be endorsed and certified so that it conveys the level of trustworthiness of the content to the Read more about Content Certification in Power BI: One Step Towards a Better Governance[…]
The question I often get in my Power BI architecture consulting sessions is; “How should we organize our workspaces? should we have one workspace with all the reports in it? Or multiple? Should we split it based on each report? Business unit? or something else?” In this article and video, I’ll explain a guide on Read more about How to organize workspaces in a Power BI environment?[…]
I have often seen Power BI users have access to areas they shouldn’t. In Power BI, you can share a report with a user just for view only or give them access to view and build or to Edit. These are all different levels of access. Build access is the one that is often confused Read more about Power BI User Access Levels: Build and Edit are different[…]
Power BI users are not all in the same category. If you treat everyone equally, you wouldn’t have a successful Power BI adoption. You would likely spend too much on the training and gain much less adoption. In this article, I’ll explain what the different types of users are and are proper actions for each Read more about The importance of knowing different types of Power BI users; a governance approach[…]