Technology Wonders

In the modern days of the application development the Power BI has been used a lot to turn related and unrelated data into the coherent, visually immersive and interactive insights. The data can be received from Excel Spreadsheets, SQL Server Database, cloud-based applications, etc. As shown in Figure 1, the Power BI can access data from various sources. Figure 1: The Get Data Features As shown in Figure 1, Power BI Uses various sources for accessing data so that it can be used by the business decision makers to get data for data transformation and use it in Visualize form to create charts Important Note: To Create database in Azure SQL and Publish API to cloud, you must have the Azure Subscription . Currently, most the data-oriented applications use REST APIs for data communications and Data fetching. Naturally, if we are using the Power BI for Data Visualization and Data Intelligence then what if the Data is to be received from the REST API then how we can access it in Power BI? In t...

ASP.NET Core is the best technology for building WEB Apps and API Services. The ASP.NET Core API offers features for building Data Communication services. We can connect various data providers to read their data and return it to the client applications. One such capability is to open an Excel file on the server and read its contents so that the client can respond to them in JSON format. Excel files play a very important role in storing data so that this data can be used for various business intelligence processes. We can develop ASP.NET Core API to directly open the Excel file on the server and return its contents to the client without downloading the file on the client. Figure 1 shows the application development process. Figure 1: Reading Excel file using ASP.NET Core API app The advantage of the above approach is that the file is available on the server and its data is sent to the client. To implement the solution we will be using the ExcelDataReader.DataSet package. This package is...