Anager of a department or 1C data synchronization in an entire australia email list enterprise needs to constantly use in order to develop for the better. In general, any information presented. A visually is perceived much easier. A so the practical use of auxiliary tools for constructing diagrams is simply necessary. There are often cases when a company maintains and stores . A information in a fragmented manner. A the nomenclature is accounted for in Excel, etc. In such a case, using Power BI is a solution to these problems.
Uploading information from 1C to Power BI
Since the IT Department Management 8 configuration supports the functionality of working with the OData interface, and the program also 1c data synchronization in power bi using odata interface keeps track of Service Desk requests or enterprise nomenclature, let’s consider the step-by-step data upload and connection to Power BI. First, you need to provide access to the database, as well as to the OData interface by publishing the configuration. To do this, open the program in the configurator mode, go to the Administration section . Publish to the web server and set the flag “Publish the standard OData interface . IIS (Internet Information Service) web server, then an additional step is to set the flag . Use operating system authentication”, which will allow you to use domain authorization when using the OData interface. After setting all the settings, click publish and if the publication is successful, a dialog box will appear, which will inform you of the successful publication.
After successfully opening access to the OData interface via WEB, we will proceed to further configuration. Open the configuration in 1C:Enterprise mode, go to the “All functions” menu and open the “Configuring the standard OData interface” processing.
Note: “To enable the .All functions” command. A you need to go to “Settings” -> “Options” and activate the “Show the “All functions” command” checkbox.
If the publication of the information
base was carried out on the . Apache web fax database server. A then by going to processing on the first tab “Authorization. A activate the flag “Create a separate user name and password for using the automatic REST service. After that, specify the user name and, accordingly. A the password for the user under which we will authorize when receiving data from the OData interface. If domain authorization was . Ainstalled during publication. A then go straight to the second tab “Composition”. This tab displays all the configuration metadata, documents, reference books, information registers, etc. Here you need to click the “Load metadata” button. Which we will then mark for publication, then click “Save and close”. All published information will become available at a link of the following type: http://ххх.ххх.х.хх/itdemo/odata/standard.odata/ .
