Category: Power BI from Rookie to Rockstar

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question

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

Bookmarks and Buttons: Making Power BI Charts Even More Interactive

Posted on by Reza Rad

In the previous post, I explained a usage of bookmarks and buttons in Power BI, which was for clearing all slicers. Buttons and bookmarks are the gold combination in Power BI. You can do wide range of creative activities with this combination. In this post, I will show you some other usages of buttons and Read more about Bookmarks and Buttons: Making Power BI Charts Even More Interactive[…]

Clear All Slicers in Power BI; A Bookmark Story

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

Usage Metrics or Do It Yourself Power BI Monitoring Report

Posted on by Reza Rad

One of the features of Power BI Service is usage metrics report on a dashboard or report. The usage metrics report will give you an analysis of how many times the content is viewed or share, through which platforms, and by which users. You can also create your own monitoring report based on the model Read more about Usage Metrics or Do It Yourself Power BI Monitoring Report[…]

Report Page Tooltip – Revolution in Visualization of Power BI

Posted on by Reza Rad

Very exciting feature that is added in the most recent version of Power BI Desktop March 2018 is Report Page Tooltips. This is a specific type of tooltip which can be a report itself. which this feature you can have your drill down report designed separately, and then with hovering on a chart, you can Read more about Report Page Tooltip – Revolution in Visualization of Power BI[…]

Power BI Embedded; Power BI in a Custom Application

Posted on by Reza Rad

Power BI leverages a very powerful method of sharing named Power BI Embedded. This method of sharing is important because of mainly two specific features of it. With this method, you can share Power BI content in your custom application, and you can share it with your custom application users, regardless if they have Power Read more about Power BI Embedded; Power BI in a Custom Application[…]

Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure

Posted on by Reza Rad

One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]