Zucchetti HR Infinity
Zucchetti HR Infinity is a comprehensive and all-inclusive Human Resources Management System (HRMS) software. It is designed to automate HR processes, manage employee records, and streamline payroll processing. Power BI is a powerful data visualization tool that is used to analyze, transform, and visualize data. In this article, we will explore how to use Power Query M Language code to connect to the Zucchetti HR Infinity data source from inside Power BI.
What is Power Query M Language Code?
Power Query M Language code is the language used in Power Query to perform data transformations. It is a functional, case-sensitive programming language that is used to manipulate and transform data. Power Query M Language code can be used to connect to various data sources, transform data, and load it into Power BI.
Connecting to Zucchetti HR Infinity Data Source from Inside Power BI
To connect to the Zucchetti HR Infinity data source from inside Power BI, we will need to use Power Query M Language code. The following steps outline how to do this:
1. Open Power BI Desktop and click on the “Home” tab.
2. Click on the “Get Data” button.
3. In the “Get Data” window, select “Blank Query” and click on the “Connect” button.
4. In the “Query Editor” window, click on the “Advanced Editor” button in the “View” tab.
5. In the “Advanced Editor” window, enter the following Power Query M Language code:
let
Source = OData.Feed(“https://myhrinfinity.com/myhrinfinity/odata”),
#”Removed Other Columns” = Table.SelectColumns(Source,{“Value”}),
#”Expanded Value” = Table.ExpandRecordColumn(#”Removed Other Columns”, “Value”, {“Code”, “Name”, “Description”, “IsActive”, “IsDeleted”}, {“Value.Code”, “Value.Name”, “Value.Description”, “Value.IsActive”, “Value.IsDeleted”})
in
#”Expanded Value”
6. Replace “https://myhrinfinity.com/myhrinfinity/odata” with the URL of your Zucchetti HR Infinity data source.
7. Click on the “Done” button to save your changes.
8. In the “Query Editor” window, click on the “Close & Apply” button to load your data into Power BI.
Understanding the Power Query M Language Code
The Power Query M Language code used to connect to the Zucchetti HR Infinity data source is an OData.Feed function that takes the URL of the data source as its argument. The OData.Feed function creates a connection to the data source and retrieves the data.
The next step in the Power Query M Language code is to remove all the columns except for the “Value” column. This is done using the Table.SelectColumns function.
The “Value” column is then expanded using the Table.ExpandRecordColumn function. This function expands the record column into separate columns for each field in the record. In this case, the “Value” record contains the fields “Code”, “Name”, “Description”, “IsActive”, and “IsDeleted”.
Conclusion
In this article, we explored how to use Power Query M Language code to connect to the Zucchetti HR Infinity data source from inside Power BI. We discussed the steps involved in connecting to the data source and the Power Query M Language code used to connect to the data source. By following these steps, you can easily connect to the Zucchetti HR Infinity data source from inside Power BI and start analyzing your HR data.