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

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

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

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

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question

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

SQL Server Reporting Services Integration with Power BI

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