Power BI, similar to Power Pivot, has a look at the tables and their relationships. Its advantage is that, from the very beginning, automatically detects relations between tables based on the name of the column that it discoveres as keys. From November 2018 the new, significantly enhanced Relationship view is offered, so in the following text it will be about what are its features and what is new.
Although Power Pivot reports still have advantages over the Matrix visual, in charge of displaying a table with a high level of detail, Microsoft persuades us day after day that Power BI will be able to carry this field as well as its “older brother”. The following text discusses the drill-down techniques used in Matrix visual and how to apply them to the selected detail, and are available since November 2018.
Power BI service, in accordance to trends, allows document sharing and collaborative work. There are multiple file sharing mechanisms, and most of them are only available to users of the Power BI Pro license, which is understandable because sharing involves working in a group, it makes no sense to share something with itself. In the following text I’ll mention address workspaces and further document sharing, how to generate QR code and monitor report statistics.
Drillthrough is an option that allows one or more reports, extracted on a separate report page, to be obtained based on the chosen dimension according to which we want to display its details. In this way, PowerBI reports get on interactivity, and by using this feature one complex report can be divided into several smaller and simpler ones, making it easier to find the information requested.
Appearance of the report is no longer only important thing, but also its interactivity. Therefore, new feature – buttons are added to PowerBI. These are graphic objects intended to give you a step backward, if you drilldown within the report, to launch a report that is recorded as a Bookmark or display a table/chart that was created as a result of a pre-designed question.