Posts

Creating Power BI reports From Microsoft Fabric Lakehouse

Image
  Wassup guys? Let's talk today about a very interesting topic of imbibing Power BI reports, fetching data from Microsoft Fabric Lakehouse . Microsoft Fabric is an extremely powerful toolhouse that encompass not just data storing and engineering mechanism, but also UI rich built-in reporting capabilities and real-time analytics. Before we begin, let me give you a short recap on what Microsoft Fabric is all about:  Microsoft Fabric  is an end-to-end analytics and data platform designed for enterprises that require a unified solution. It encompasses data movement, processing, ingestion, transformation, real-time event routing, and report building. Microsoft Fabric is a data analytics platform that helps organizations manage, access, and act on data. It's designed to address all aspects of an organization's analytics needs, including all ingredients of data movement like: data processing, ingestion, and transformation, as well as real-time analytics to allow users to explore,

Using Fan-in, Fan-out model on Azure functions to integrate with D365F&O

Image
  ¿Amigos, Commo estas? Fan-out/fan-in refers to the pattern of executing multiple functions concurrently and then performing some aggregation on the results. This article explains a sample that uses Durable Functions to implement a fan-in/fan-out scenario. The sample is a durable function that backs up all or some of an app's site content into Azure Storage. In layman's words: Azure functions are stateless executions, they would not able to retain anything between different calls. Durable functions allow them to retain things betweeen the calls. This article is about leveraging Durable functions to perform CRUD operations to D365F&O, that too in a real time/near real time condition.  Here is the scenario: Background: We have a large volume of incoming data payload coming through HTTP request body, and we need to make it to flow to Finance&Operations application. The following article explains how to implement a Duarable function, on such a situation, step by step.Thi

Step by step: Connecting Azure Cosmos Db to Azure Dynapse Analytics

Image
  Wassup Guyz? Today will talk about Linking Azure Cosmos DB to Azure Synapse Analytics, and then dealing with its migrated data.  As we all know, Azure Cosmos Db had been in the market for quiet a time now. Azure Cosmos DB is a globally distributed, multi-model database service offered by Microsoft. It is designed to provide high availability, scalability, and low-latency access to data for modern applications. It is a fully managed NoSQL and relational database for modern app development, whereby you can store the humongous volume of dataset, allowing them to be easily replicated across regions/locations, in a most effective way. Essentially in a Cosmos DB, we create a Database (we call it a TodoList) and inside it the we keep Tables (called as Items), into which we can keep our records. And as you have rightly guessed, the reccords are stored in form of JSON structures, and you have provision to query the records and even create triggers/stored procs on them. Creating a Cosmos DB i