How to download files from Microsoft Fabric Lakehouse ?

 Challenge:

Yesterday I was trying to download a parquet file from the Microsoft Lakehouse on to my laptop.  So I was searching for the download link.  

But I could not find one.

Solution

Easiest way is to download the Onelake explorer from this link OneLake explorer and use that to browse and download the parquet files.  It works much like Onedrive.

You can also use Python in a Fabric notebook -- Link here

Free Power BI Classes week 5

Yesterday I completed the Power BI Class for week 5

We continued with Lab 3 and completed both Lab 3 and 4.

The participants learnt about formatting page background, inserting images, bookmarks, publishing the report to Power BI Service, creating mobile layout and more.  

Here is the recording of the class for week 5

Free Power BI Classes Week 5

Free Power BI Classes Week 4

Just now completed the Power BI Class for week 4

We continued with Lab 2.

The participants learnt about creating hierarchy, difference between calculated column and measures, DAX formulas for calculating Previous year sales and % Growth.  

Then we started with Lab 3 which mainly is focused on Data Visualisation.  They learnt about conditional formatting,  formating options in each visual, Themes and formating slicers.

Here is the recording of the class for week 4

Free Power BI Classes 2025 Week 4

Free Power BI Classes Week 3

Successfully completely the free Power BI classes for week 3

We continued with Lab 2.

The participants learnt about creating stacked column charts by using legend functionality, creating groups, creating filters on the visual and page level filters as well creating drill down charts based on date hierarchy.  They also created slicers.

Some interesting questions also arose as now the participants started thinking of how to analyse the data at hand.

Here is the recording of the class for week 3

Free Power BI classes 2025 Week 3 

Free Power BI Classes for Week 2

Successfully completely the free Power BI classes for week 2

We completed Lab1 and started on Lab 2.

The participants learnt about data modelling, facts/measures and dimensions

They also learn about Relationsips -- 1 to Many and Many to Many relationships and how to create them in Power BI

Here is the recording of the class for week 2

Power BI Classes Week 2

Free Power BI Classes Week 1

Yesterday I have started free Power BI classes for adults.

These classes are aimed at people who are new to Power BI.  I will be covering the Dashboard in a Day labs over 6 weeks.

We started off with Lab 0 and Lab 1.

Here is the recording for yesterday's one for those who would like to start off with Power BI

https://youtu.be/tvVkdmMOSJU

• 😇
• 💗
• 🙏

Free Power BI Classes 2025

Free Power BI Classes 2025

youtube.com

OneLake: The Heart of Your Data Universe in Microsoft Fabric

Imagine a single, unified data lake for your entire organization, accessible to every workload, without data duplication. That's the power of Microsoft Fabric's OneLake. It's not just a storage solution; it's a foundational layer that fosters data collaboration and streamlines your analytics journey.

Understanding the Core Concept of OneLake

OneLake is fundamentally a single, unified, SaaS-managed data lake built on Azure Data Lake Storage Gen2 (ADLS Gen2). It's automatically provisioned with every Fabric tenant, eliminating the need for manual setup. Key concepts include:

• One Copy of Data: OneLake eliminates data silos by providing a single, logical location for all your data, regardless of format or source.
• Hierarchical Structure: It uses a familiar hierarchical file system, allowing you to organize data into folders and subfolders.
• Shortcuts: OneLake shortcuts enable you to reference existing data in other storage locations (like ADLS Gen2 or S3) without physically moving it.
• Open Formats: It supports open data formats like Parquet, Delta Lake, and CSV, ensuring interoperability with various tools and applications.
• Automatic Indexing and Discovery: OneLake automatically indexes metadata, making it easy to discover and access data.

Advantages of OneLake: A Game Changer for Your Data Strategy

• Eliminates Data Silos: OneLake breaks down data silos, fostering a unified view of your organization's data.
• Reduces Data Duplication and Costs: By storing data in a single location, OneLake eliminates the need for redundant copies, reducing storage costs and complexity.
• Simplifies Data Management: OneLake's SaaS-managed nature simplifies data management, freeing up IT resources.
• Accelerates Analytics: With all data in one place, OneLake accelerates data access and analysis, enabling faster insights.
• Enhances Collaboration: OneLake promotes data sharing and collaboration across teams and departments.
• Seamless Integration with Fabric Workloads: OneLake is tightly integrated with all Fabric workloads, including Data Factory, Data Warehouse, Lakehouse, and Power BI.

How OneLake Fosters Data Collaboration

OneLake acts as a central hub for data collaboration, enabling teams to easily share and access data. Here's how:

• Shared Workspaces: Fabric workspaces provide a collaborative environment where teams can work on data projects together, with OneLake as the underlying storage.
• Data Sharing through Shortcuts: OneLake shortcuts allow teams to easily share data without physically moving it, reducing data duplication and ensuring data consistency.
• Data Discovery with Metadata: OneLake's automatic indexing and metadata management make it easy for teams to discover and access relevant data.
• Consistent Data Access: OneLake provides a consistent data access layer, ensuring that all Fabric workloads can access data in the same way.

Scenarios and Examples:

• Scenario 1: Cross-Departmental Analytics:
  • A retail company wants to analyze customer behavior across different departments (marketing, sales, and operations).
  • With OneLake, each department can store its data in separate folders within the same data lake.
  • Data analysts can easily access and combine data from different departments to gain a holistic view of customer behavior.
• Scenario 2: Data Science Collaboration:
  • A data science team wants to collaborate on a machine learning project.
  • They can store their data and models in a shared workspace within OneLake.
  • This enables team members to easily access and share data, code, and models, accelerating the project lifecycle.
• Scenario 3: External Data Integration:
  • A financial services company needs to integrate data from external partners.
  • Using OneLake shortcuts, they can reference data from their partners' ADLS Gen2 accounts without physically moving it.
  • This simplifies data integration and reduces the risk of data duplication.
• Scenario 4: Real-time Data Sharing:
  • A manufacturing company has IoT devices that are constantly generating data.
  • This data is streamed into OneLake.
  • Different teams can access the most recent data instantly for real time dashboards, and alerting.

The Future of Data Collaboration is Here

OneLake is a transformative technology that simplifies data management and fosters data collaboration. By providing a single, unified data lake for your entire organization, OneLake enables you to unlock the full potential of your data and accelerate your analytics journey.