Basic indicators of advertising effectiveness on Google

Unlike the previous methods after creating the dataset further work with the report continues in Power BI Desktop. This gives you access to all types of visualizations including those that can be added using the Get more visuals option. For a change in this exercise we will create the dataset entirely via the REST API. I encourage people who want to experiment to read the REST API documentation and the documentation for cmdlets supported by Power BI. Appendix contains an example PowerShell script that installs the necessary modules to support Power BI then connects to Power BI Service finds a workspace with the given name and creates a new dataset.

The command that creates the dataset contains the defaultMode flag. The flag can take several values which are described in detail in the REST API documentation. The Streaming flag will create the data source described in the previous section. The PushStreaming flag will Email Marketing List create a Push dataset while the Push flag will create a classic dataset so be careful not to get confused. This exercise uses the PushStreaming flag. Thanks to working in Power BI Desktop it is possible to fully configure all elements of the appearance of a given visualization.



Unfortunately not all setting options are ultimately supported after the report is sent to the server. You will see this at the end of the example below. We start preparing the report by connecting to the data source. After clicking Get DataPower BI datasets a window will appear in which you will be able to find the dataset created in the previous step. Because the Color and Percentage columns are numeric Power BI tries to aggregate them which is the default behavior.