Power BI Summit 2021 – A great success, Thank YOU

It took us a while to get back to business as usual and have time to write about the Power BI Summit. We are fortunate that we have so many wonderful speakers, staff, and sponsors who helped us run this event, and the feedback we got was just amazing. In this post, I’ll share some Read more about Power BI Summit 2021 – A great success, Thank YOU[…]

All Power BI Announcements of Microsoft Business Applications Summit 2021 in One Place

The Microsoft Business Applications Summit 2021 happened recently, just a couple of weeks after the Power BI Summit, and there were a bunch of exciting announcements and updates from the Power BI team. If you missed seeing them all in one place, this article and video are a nutshell of all of those in one Read more about All Power BI Announcements of Microsoft Business Applications Summit 2021 in One Place[…]

Multi-Select Slicer in Power BI

This is a very short, simple article about how to have a multi-select slicer in Power BI. Power BI slicer is in fact multi-select by default, however, there is a very small option that if you set it, makes it even easier to use, let’s talk about it. If you want to learn more about Read more about Multi-Select Slicer in Power BI[…]

Day of Year and Day of Quarter – DAX calculations for Power BI

Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI[…]

Power BI Design Tip: Disable the Auto-Detect Relationship

Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. In Read more about Power BI Design Tip: Disable the Auto-Detect Relationship[…]

Power BI Quick Tip: the Formula Bar in Power Query

Often you do the transformation in Power Query using the graphical interface, but having the formula bar visible, makes it much easier to understand or change the transformations. In this short blog and video, I’ll explain that. Power Query transformations In Power BI, we use Power Query a lot for transformations, but mostly using the Read more about Power BI Quick Tip: the Formula Bar in Power Query[…]

Dataflow: a remedy slow data sources in Power BI

I have previously explained a number of use cases for dataflows. One really useful case for it is to use dataflow for slow data sources. In this short article and video, I’ll explain how this works. What is a dataflow? Dataflow is a Power Query process that runs in the cloud and stores the result Read more about Dataflow: a remedy slow data sources in Power BI[…]

How to modify a linked entity in Power BI dataflows

It is not possible to change a linked entity in a dataflow in Power BI. Linked entities has to be modified only in the dataflow in which they are created. However, sometimes, you need to do a small modification to the linked entity in a chained dataflow. There is a very simple trick, In this Read more about How to modify a linked entity in Power BI dataflows[…]

How to stop your Power BI tenant becoming a dataset swamp?

Self-service BI! This is what Power BI is all about for business users. They can connect to any available data source and start creating their own reports. However, great Power (BI) comes with great responsibility as per Uncle Ben and not sure business users are aware of their responsibilities when it comes to Power BI Read more about How to stop your Power BI tenant becoming a dataset swamp?[…]

How to organize workspaces in a Power BI environment?

The question I often get in my Power BI architecture consulting sessions is that; “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 Read more about How to organize workspaces in a Power BI environment?[…]