Connecting to Power BI

Let’s open and run Connecting to Power BI the power . BI belgium email list desktop program, which can be downloaded for free from the official Microsoft website. In order to connect and then download the data received from 1C, go to the “Get data” section in the top menu and select “OData channel” from the list. In the dialog box that appears, specify the URL for connecting to the information and click “OK”.Connecting to Power BI

After this, the program

will ask you to enter the Connecting to Power BI authorization data  1c data synchronization in power bi using odata interface that you specified at the stage of setting up the 1C configuration. After this, the program will open another dialog box in which the received data will be displayed. Next, you need to transform the received information. To do this, click the button of the same name “Transform data”. Using DAX formulas, which are close to Excel formulas, we will perform the transformation and move on to distributing connections between queries.

As an end-to-end example, we will load data from the Task document and the Users directory, as well as the Services directory, and perform the above actions. As a result of the transformation and establishment of links between queries, we can visualize the information. In the pie chart, we will display information on the amount of influence on the task for a specific user of the centralConnecting to Power BI

information base.

And in the analytical object “Sensor” fax database of the Power . BI program, we will display the number of services involved in tasks from the total number. This will allow you to see advanced analytical information on the configuration data. In this way of using the downloaded information from the configuration. IT Department Management 8″ you can expand the list of standard analytical reports and conduct the necessary analysis of work. As a result, this software tandem will allow you to make competent management and commercial decisions in running a business. That’s all, all the best and good luck.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top