Nikil Prabhakar Nikil Prabhakar

Are you sure you are using Direct Lake connection ? Here is how to validate

The key differences between Direct Lake and Direct Query modes

  • How each mode impacts data retrieval and performance

  • The tools you can use to validate if you're using a Direct Lake connection, including Query Analyzer and Profiler

By the end of this tutorial, you'll have a clear understanding of which mode to use for your specific data analysis needs and how to ensure your connections are correctly configured.

Read More
Nikil Prabhakar Nikil Prabhakar

Role-Based Data Access for OneLake in Fabric | Step-by-Step Tutorial

In this video, we'll guide you through the entire process of setting up role-based security for your data in OneLake. Whether you're a beginner or looking to refine your skills, this tutorial will help you ensure that your data is accessed securely and appropriately within your organization.

What You'll Learn:

  • Understanding the basics of role-based data access

  • Step-by-step configuration of security settings in OneLake

  • Best practices for managing user roles and permissions

  • Troubleshooting common issues

Read More
Andre Fomin Andre Fomin

Forecasting with LLM and GenAI in Microsoft Fabric

What!!??!! #Azure #OpenAI can be used for #forecasting and making #predictions? In #MicrosoftFabric ??? Yes, Yes, and Yes! Enough with Copilots and Assistants, let's talk about using #GenAI to drive business outcomes, no data science degree required.

Today, we're tackling a topic you probably haven't seen before: how to forecast and make predictions in Microsoft Fabric using Generative AI and Large Language Models (LLMs).

While most videos focus on LLMs as assistants or copilots, I find that use case uninspiring and soon-to-be commoditized. Instead, I'm focused on logic intelligence—applying GenAI to core app logic, business, and data processing.

In this video, we'll cover:

  • Setting up the environment and data for predictions.

  • Using LangChain and Azure's OpenAI for data analysis.

  • Predicting restaurant tips based on customer and waiter demographics.

  • Comparing LLM-based predictions with traditional math-based methods.

We'll start with the setup, move to prompt creation, and show you how to leverage LLMs for accurate predictions.

If you're as tired as I am of hearing about assistants and copilots, and you're ready to see how GenAI can actually drive business outcomes, you're in the right place.

Remember to like, subscribe, and leave a comment if you have questions.

Read More