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?[…]
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[…]
Datamart, Dataflow, and Dataset are all Power BI components dealing with the data. I have presented about these a lot, and one of the questions I get is: What is the difference between Dataflow, Dataset, and Datamart? So I thought to explain it in an article and help everyone in that understanding. In this post, Read more about Power BI Datamart Vs. Dataflow Vs. Dataset[…]
Using Power BI is simple. However, using it properly needs a good architecture. In a multi-developer environment, the architecture of a Power BI implementation should allow multiple developers to work on the same solution at the same time. On the other hand, the Power BI architecture should be designed so that different layers of that Read more about Power BI Architecture for Multi-Developer[…]
Have you ever had a situation where you want to re-use part of the model in another report? Imagine two report visualizers in your team who want to create Power BI report visualizations from your data model. You have already done some modeling and calculations. How can this be done the best way without a Read more about Power BI Shared Datasets: What is it? How does it work? and Why should you care?[…]
Dataflows are an important component in the Power BI architecture. Using them can enhance the development and maintenance of your Power BI solution significantly. However, there are many Power BI implementations that are not using this functionality, even though it is already more than three years passed since it was released. In this blog and Read more about What are Power BI Dataflows and their Use Cases?[…]
Power BI supports different methods for connecting data. That is why the decision to choose the right method is always a tough decision. You have heard of DirectQuery, Live Connection, Import Data, and there is also a Composite Model. What do these actually mean? and what is the situation in which you should choose one Read more about Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision![…]
One of the newest additions to the Power BI components is the Datamart. Power BI Datamart is more than just another feature, it is a major milestone where the development of Power BI solutions will be revolutionized based on that. This is a feature that helps both citizen data analysts and developers. In this article Read more about Power BI Datamart – What is it and Why You Should Use it?[…]
Dataflows are useful for many scenarios when dealing with Power BI. One of their big advantages is the data source isolation and anything that comes with that. Benefits of such architecture are many, including datasets independent from the data source changes, and managing security in another layer from the data source. In this article, I’ll Read more about Power BI data source isolation using dataflows. How is it and what are the benefits?[…]
Implementing a Power BI solution is not just about developing reports, creating a data model, or using visuals. Power BI, like any other technologies, can be used in a correct, or incorrect way. Any technology can be used more effective if it harnesses the right architecture. A right architecture can be achieved after a requirement Read more about Power BI Architecture Guidelines[…]