Azure, AI, SP, .NET, Microsoft - Knowledge Base

Business Case- Create one simple ChatBot with RAG support Issues Once I created the project and place my blog url as data source, Vector data base in Azure unable to create the index and get the data. Also, it unable to show me any log data. Next I thought my Blog data might be very small or heavy for Azure :). Let's try with Kaggle data. I found below the Fashion data set online available at Kaggle site:  https://www.kaggle.com/datasets/nirmalsankalana/fashion-product-text-images-dataset Azure is ready to create the Vector database and index for me, that's Great:) Again, looks like Azure got confised and unable to manage.  As I'm doing all these activities on a major AI platform, and my expectation was if there is any issue, Azure AI will fix that one and let this ready for me.  And I was wrong again :( Same thing, Azure unable to provide me any kind of log, The last thing I tried to place a sample answer about myself through System message.  Fortunetly, this works ...

Micrsoft bring a new plan for Azure Function - Flex Consumtion Plan for hosting. It is Linux based Azure Functions hosting plan. Below a quick sneek preview of the plan. And here is more details . Pretty simple way to create Azure Function. Created by a minute, and below my Azure Function is up and running. Let's try to enable managed identity in Azure Function. 1. Click on your Azure Function and bring the Function dashborad 2. Click on Identity under Settings 3. On the System assigned tab, switch the status to On and click save Next, you need to assign the roles to he Managed identity. To do so, first you browse to the respective Azure resources like Azure Storage/SQL DB/key Vault and assign the necesarry role-based-access-control (RBAC). Let's create a key Vault first and assign the  Afterwards, select the subscription and search your RBAC role and assigned the sale. Click on Save. Now, go back to Functon dashboard and then Settings >> Identity and then Azure Role ...

On-premise data gateway - one of the important feature/service Azure Fabric platform is using to bring your on-premise data into Azure cloud. The data movement is secure and encrypted. You can review my my earlier post  https://splaha.blogspot.com/2025/03/use-on-premise-gateway-in-fabric-and.html   where I explain how to configure On-premise data gateway using Step 1 and Step 2. In this exaple, I'm going to use the same data conenction to pull my on-premise SQL tables using custom join SQL into Lakehouse. The entire post is self explanatory with step-by-step snapshot. I hope this will help you to understand each and individual steps as well as to execute the same at your end. Let's start with my on-premise SQL server details. As you can see the below picture, it talks about the database Employee where there are two tables EMP and DEPT. I'm going to use the same SQL into Fabric to pull the data. I assume you already created the on-premise data gateway using my earlier post...

On-Premise data gateway is an application which is required to be installed in your laptop/computer/server which connect to cloud and uses cloud services to send data back-and-forth from on-prem to cloud. This is secure data connection and data encryption is in place. Here is more about on-premise data gateway - https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem?toc=%2Ffabric%2Fdata-factory%2Ftoc.json https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem?toc=%2Ffabric%2Fdata-factory%2Ftoc.json Architecture of it - https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth?toc=%2Ffabric%2Fdata-factory%2Ftoc.json https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem-indepth?toc=%2Ffabric%2Fdata-factory%2Ftoc.json Step 1 First thing first - You need to install on-premise data gateway in your lcoal. Second thing is to open the on-premise data gateway and ensure th...