In an old cartoon was promoted a saying: “Cats and mice can be friends”. Consequently, Excel and Power BI can also be friends! Power BI allows you to import Excel reports, whether traditional, Pivot or Power Pivot reports. This is not a whole new topic, but I think it would be nice to remember it in a new light, with an emphasis on what you can do for free and when you definitely have to buy licenses.
In a previous “recipe” you’ve met PowerBI work environment and ways to create reports and dashboards. In the following post I will introduce you to the featured dashboards, favorites, groups and workspaces, display and filtering the content that appears in the menu. Also, there will be words and the additional options to edit, add content and share dashboards. Most of these options can be used in the free variant PowerBI service.
In the previous “recipe” was the word on how to import data to PowerBI and I have listed a number of sources from which it can connect. In what follows we will focus on the description of the user interface, and then you will see at practical example how to make reports and add them to dashboards. We will not be focusing on details but I believe you will, after reading this article, be able to independently create PowerBI reports.