Eduframe
Power BI is a powerful tool for data visualization and analysis. It helps organizations to understand their data better and make informed decisions. One of the great features of Power BI is its ability to connect to various data sources. In this article, we will focus on connecting to the Eduframe data source using Power Query M language.
What is Eduframe?
Eduframe is a cloud-based software solution designed for training providers to manage their entire business process. It provides a comprehensive set of tools for managing student administration, course management, finance, and reporting. Eduframe is a popular choice for training providers, and many organizations rely on it to manage their training programs.
Connecting to Eduframe Data Source
To connect to Eduframe data source from inside Power BI, we need to use Power Query M language. Power Query is a data transformation and cleansing tool that is built into Power BI. It allows users to connect to various data sources, transform data, and load it into Power BI. Power Query M language is used to write the code that connects to the data source.
Here are the steps to connect to Eduframe data source using Power Query M language:
1. Open Power BI and click on the Get Data button from the Home tab.
2. Select Web from the list of available data sources.
3. In the From Web dialog box, enter the URL of the Eduframe API endpoint. The URL should be in the following format: https://your.education.com/api/v1/.
4. Click on OK to connect to the Eduframe API endpoint.
5. In the Navigator dialog box, select the tables that you want to import into Power BI.
6. Click on Edit to open the Power Query Editor.
Writing Power Query M Language Code
Once you have loaded the data into Power Query Editor, you can write the Power Query M language code to transform and cleanse the data. Power Query M language is a functional programming language that is used to write the code that connects to the data source and transforms the data.
Here is an example of Power Query M language code that connects to the Eduframe data source, retrieves the data, and transforms it:
let
Source = Json.Document(Web.Contents(“https://your.education.com/api/v1/”)),
Courses = Source[courses],
#”Converted to Table” = Table.FromList(Courses, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#”Expanded Column1″ = Table.ExpandRecordColumn(#”Converted to Table”, “Column1”, {“id”, “name”, “description”}, {“id”, “name”, “description”})
in
#”Expanded Column1″
In this code, we first use the Json.Document function to retrieve the data from the Eduframe API endpoint. We then select the courses table from the data source and convert it into a table format using the Table.FromList function. Finally, we expand the columns of the table using the Table.ExpandRecordColumn function.
Conclusion
Power Query M language is a powerful tool for connecting to various data sources and transforming data inside Power BI. In this article, we have discussed how to connect to the Eduframe data source using Power Query M language. By following the steps outlined in this article, you can easily connect to the Eduframe data source and retrieve the data that you need for your analysis.
