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

Download your certificate of completion after you finish this course: 📄 prag.works/202307-lwtn-certificate Student files ✔prag.works/lwtn-microsoft-fabric-files

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

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

Pragmatic is most underrated channel out there

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 ?

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?

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.

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!

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

Austin my man! LY bro

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

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

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.

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

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?

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

Waiting for the files. Thank you for the class.

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?

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

Hi Austin, sorry to bother you again. But I get stuck with the dimDate table, is that after I'm using it in my Power BI Dekstop, I cannot "Mark as date table". Although I already add new column in my PBI Desktop using this DAX: Date = DATE(Dates[CalendarYear], Dates[MonthNumberOfYear], Dates[DayNumberOfMonth]). Turns out when "Mark as date table", only this column appear in the selection to choose column with, it is validated successfully but then error saying "The calculated column "Dates[]" cannot be used as a primary key of the table". Do you have any idea what's the problem, and how to mark this as a date table ? Thanks in advance.