What is the Direction of Relationship in Power BI?

Posted on July 11, 2018October 7, 2021 by Reza Rad

Relationships in Power BI are a bit different from other database management systems. In most of the systems, you just have a relationship and there is no “Direction” for it. In Power BI, however, there is a direction for the relationship. The direction of a relationship plays a critical role in the way that filtering Read more about What is the Direction of Relationship in Power BI?[…]

Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI

Posted on July 10, 2018 by Reza Rad

Sometimes for tables with too many columns, and also for databases with too many tables, you do need a bit of help to explore the data. As an example; you know that you are looking for a column named “account status”, but the column does not exists in the accounts table. You need to search Read more about Search for a Column in the Entire Database with Table.ColumnNames in Power Query and Power BI[…]

Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX

Posted on July 2, 2018 by Reza Rad

Parent-child functions in DAX are very useful for parsing an organizational hierarchy or something like a chart of accounts. Usually, for hierarchies that the number of levels is not determined, you need to use a different method, and parent-child functions in DAX are a big help for that type of hierarchies. In this post, you Read more about Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX[…]

Week to Date Calculation in Power BI with DAX

Posted on June 29, 2018 by Reza Rad

There are a number of pre defined DAX time intelligence calculations that help you to get analytics over time, such as year to date, same period last year, and etc. However, there is no calculation for Week to Date built-in. I have found it quite a demand for some of businesses, as many of businesses Read more about Week to Date Calculation in Power BI with DAX[…]

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question

Posted on May 29, 2018October 7, 2021 by Reza Rad

Using DAX time intelligence functions for a while; you may ask this question from yourself that what is the difference between functions below; SamePeriodLastYear function vs using ParallelPeriod with Year parameter ParallelPeriod for a month vs DateAdd for a month ago and many other questions that lead to this final question: Which function should be Read more about DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question[…]

Clear All Slicers in Power BI; A Bookmark Story

Posted on May 11, 2018October 7, 2021 by Reza Rad

Using bookmarks for clearing all slicers in Power BI is not a a new function, I have been using it for many months, and advising many people to do it that way. However, I still get a lot of questions in my presentations about how to do that. That is why I ended up writing Read more about Clear All Slicers in Power BI; A Bookmark Story[…]

Power BI Architecture Guidelines

Posted on May 2, 2018October 7, 2021 by Reza Rad

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

SQL Server Reporting Services Integration with Power BI

Posted on May 1, 2018 by Reza Rad

Power BI Report Server can host Power BI reports on-premises, and you’ve learned about it in the previous post. There is another integration between SQL Server Reporting Services and Power BI service; this integration brings tiles from SSRS reports pinned to a Power BI dashboard with scheduled updates from SQL Server agent. The integration of Read more about SQL Server Reporting Services Integration with Power BI[…]

Power BI Export to Power Point: Things You Need to Know

Posted on March 28, 2018 by Reza Rad

Exporting a Power BI report to PowerPoint is a good way of integrating these two tools together. The analytical power of Power BI combined with the commentary and presentation features of PowerPoint enables you to present your reports differently. You can export almost any Power BI report (limitations mentioned in this post) to PowerPoint, and Read more about Power BI Export to Power Point: Things You Need to Know[…]