Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used tables

I started Power BI Helper with the intention to help to find issues in Power BI reports faster and easier. This tool over time became better and better. I’m excited now to let you know that the version 2.0 of this product is now available for everyone to use and enjoy. This version comes with Read more about Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used tables[…]

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 about DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question[…]

Bookmarks and Buttons: Making Power BI Charts Even More Interactive

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

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

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

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 Announcements in Data&BI Summit 2018 Dublin Keynote

I am seating in the front row of keynote for Data and BI Summit 2018 in Dublin ran by Dynamic Communities. There will be some great announcements today about upcoming Power BI features. Here in this blog post I will list these features. Incremental Refresh The most wanted feature of Power BI for refreshing data Read more about Power BI Announcements in Data&BI Summit 2018 Dublin Keynote[…]

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

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

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

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