Creating A Microsoft Fabric End-To-End Solution ⚡ [Full Course]

Download your certificate of completion after you finish this course:
Student files

Prepare to revolutionize your data universe! Are you tired of battling against disruptive data silos that sabotage your organization's natural flow? Have you grown weary of futile attempts to construct a data warehouse or lakehouse, realizing the colossal waste of time and energy? And let's not forget those individuals lost in the labyrinth, desperately seeking access to the elusive data required for their crucial reports.

Fear not, for salvation has arrived in the form of Microsoft Fabric!

Microsoft Fabric is the veritable holy grail of analytics solutions, encompassing a breathtaking array of full-service capabilities. Behold the marvel of seamless data movement, awe-inspiring data lakes, and the sheer power of data engineering, integration, science, real-time analytics, and business intelligence all in one extraordinary package.

Delve into the boundless possibilities of Power BI, Synapse, and Data Factory as you unlock the mysteries of this groundbreaking offering. Whether you're a daring data engineer, a visionary scientist, a sharp-witted analyst, or even a wordsmith weaving reports, Microsoft Fabric unveils a world of limitless potential.

Prepare to be mesmerized as we unravel the enigmatic wonders of OneLake, the crown jewel of Microsoft Fabric. Within this lake-centric architectural masterpiece, data professionals and the business elite unite, forging an unbreakable bond of collaboration on daring data projects.

Get ready to transcend the ordinary and embrace the extraordinary. Microsoft Fabric awaits, ready to propel your organization into an exhilarating new era of data-driven success!

Next event:
Mini Hackathon 2023 with Brian Knight

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

#Fabric #PragmaticWorks #AustinLibal #Training #Microsoft #Tech #FreeConference #LearnWithTheNerds

**Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only.

[PragmaticWorks]

Download your certificate of completion after you finish this course:
Student files

[MubarakAli-cbcq]

00:03 Microsoft Fabric is an end-to-end analytics solution with full service capabilities.
06:30 Fabric enables a wide range of tools in the Power BI service.
17:53 Fabric is a one-stop shop for analytics, visualization, storage, sharing, and integration.
22:50 Create a workspace with fabric enabled and a lake house called Adventure Works.
32:36 Creating a connection and loading data to a Lake House using Power Query
37:20 Create tables in Adventure Works lake house and load data from Excel workbook
47:26 Different Microsoft products available. Live teachings provide in-depth learning.
52:39 Use historical versions of Delta table for data analysis and recovery
1:02:46 You can easily upload and analyze delimited text files in Power BI Lakehouse.
1:07:36 Clicking the new Power BI data set and selecting tables from the data lake
1:18:23 There are two ways to update data in the lake house: data flow and pipeline.
1:23:06 Data Factory pipelines and activities can be used to move and process data

[juliestudy]

Hi Austin, your tutorial has been most helpful! Thank you so much for sharing!

[xlrutwg]

Hey, would love to see you do a video on governance. How do you secure (delta) tables? Can you secure them in Lakhouse and have same security in Warehouse and PowerBI?

[austinlibal]

Hey friends! Thanks for watching our Fabric LWTN session! I want to do some spin off videos from this session to continue discussing capabilities within Fabric and want to know what you are most interested in? Spark Notebooks? Data Warehouses? Datamarts? Let me know in the comments! Thanks!

[SudarshanThakurIRONPULLER]

HI Austin, Very informative .Just a question :Can we user One lake as Open search and key based search ? And also can we store PDF, html, images so that users can download then directly from data lakes based on key ?

[clodola]

Thanks very informative, Q on the PBI dataset provisioned from a Lakehouse via directlake storage mode, the RBAC Security tab is blanked out, Is this not available yet? I cannot find anything online

[Babayagaom]

Pragmatic is most underrated channel out there

[niranjanmakkuva]

Do we have a way to track the transformations we have done using data flow, I mean logging the details that we applied pivot, groupby and merged table 1 and table 2 to create table 3

[brycedwhite]

I followed along with your walkthrough, but Fabric did not create a default power bi dataset and I have no button to create a new power bi dataset. I have a trail Fabic license and a PPU license for power bi - if this matters.

[niranjanmakkuva]

I have a question, can we dynamically pass a query to the data flow (I need a flow to read from txt file the query and copy to a destination) eg i have a file with tablename the df should read from source and copy to destination

[ljfkdgh]

Hello sir,
Thank you so much providing these productive videos.

Today, I faced a challenge, and the solution I couldn't find elsewhere.
That is

How to Extract data from SAP Hana Cloud to Microsoft Fabric (cloud to cloud connectivity). Could you please help me here?

[pwasoo]

Hi Austin, I am getting this error when trying to create a relationship between FactInternetSales & DImProduct in PowerBI Dataset (1:10:00).
"Free User cannot apply model changes, upgrade to PowerBI Pro "
How did you got it working?

[excelexperttraining]

Hi Austin, what should I do if I am getting this error message -- TypeError: Cannot read properties of undefined (reading 'toResource')
-- when trying to connect to a lakehouse (workspace) through the data pipeline process you have in the video. I don't have the Lakehouse in the list. thanks

[vtlcngp]

Hi Austin
While I followed your steps, there was no SQL endpoint created in my space (44:00). How do I resolve it?

[theonlymattkone]

Does this work for multiple tiles that have the same data in it? Say I have Receipts by month from FY 2023, and I want to combine all of the files in a folder - similar to how I would in PQ on Excel or PBI Desktop - Could I do that if the files are being stored in the lakehouse?

[antonzhong]

Awesome video, Austin. May I ask, at 1:16:00, when we want to connect and use Power BI Dataset in Power BI Desktop, if lets say the person is different person which is not create the whole OneLake and Lakehouse and this person only want to use the dataset which given by their company admin, will the person only need Power BI Pro license ? Any other license that he/she might able to have for just connect and use that "given" dataset ?
Thanks for your video, it really helps.

[ljfkdgh]

Sir,
How can we build the JDBC/Pyodbc connection between Fabric Data warehouse and Fabric Notebook.

I have been finding it since a long time, but un-successful

[samihnaien]

dans t-sql dans data warehouse il ya beaucoup de fonctionnalités manquant comme alter table add column... ya t´il des alternatives ?

[yvfwcbp]

Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: 值无法更新。 why happen this error on dataflow Gen2