Microsoft Fabric - Step-By-Step Learning Notes

So far, what we have learned in Data Engineering area specific to Microsoft Azure Cloud - Starting with Azure Data Factory, and then Data Flow, Data Bricks, SCALA, Python, Azure Synapse, and finally we are landing to prepare visualization report using Micrsoft Power BI. 

Azure provides inteligency applicable areas for handling data and prdiction - We use Micrsoft Machine Learning workspace and its services. Matured platform providing services and easily plug-and-play model.

Micrsoft now presents Fabric - the BIG jump in this era - At enterprise level, this includes everything under one umbrealla - It brings together experiences such as Data Engineering, Data Factory, Data Science, Data Warehouse, Real-Time Analytics, and Power BI onto a shared SaaS foundation. 




                                                             (Picture from Mocrsoft Fabric site)



To get into Fabric, Micrsoft offering trail version and good to get insight to have a look at it.

Power BI users can skip trail, however for test of the world, here the link to start - Start the Fabric trial.

Following are steps by steps approch on how you can create your Fabric work space and upload data or existing report file. 


Step 1: Visit the link Start the Fabric and start your trail


Fabric Home Page



Step 2: Create Your FirstWorkspace 

Under Power BI segment, you can actually upload your existing report in 1 click. Upload your existing Power BI report file. Fabric will do the rest for you :)


Nice to found your old reports is in Fabric in seonds. Click on the files and reports to display them in Fabric.




Now, let's try to create a Lake House in Fabric. Click on New and then Option at the end, and in next page select 

Step3: Create  Lake House




Next, I'm going to upload some excel file here. Here in Git, some example files you can download for this https://github.com/microsoft/fabric-samples/blob/689e78676174d4627fc3855165bde9100cb4d19e/docs-samples/data-engineering/dimension_customer.csv 

 





Good option here is uploading file can be connected with you M365 SharePoint/Onedrive.



Other option is you can select for Authentication and privacy level.  Good for using service account and specific audience.




Step4: Upload the data and click next to review and publish



Review the Data Destination option here. Make sure right option is getting selected.



Finally, click on publish to save the data in Lake. 



You now able to save your first data in lakehouse.....Congratulations!



Comments

Post a Comment

Popular posts from this blog

How to fix Azure DevOps error MSB4126

Image
Setting up build and release pipeline always tedious and we face many build related issues. Here is one common error I face couple of times while setting app Web or windows apps in Azure DevOps After placing the code in repos, and creating the build pipeline and run it, you can face the following error ##[error]D:\a\8\s\<your solution file>.sln.metaproj(0,0): Error MSB4126: The specified solution configuration "release|$(BuildPlatform)" is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those properties blank to use the default solution configuration. To understand what is target platform defined in your project you need to visit or open the solution(.sln) file and review the following sections. In my case, this has been defined as x86 as target platform.                   GlobalSecti
Read more

How to create Custom Visuals in Power BI – Initial few Steps

Image
This post will help you to know the steps to create custom visuals in PowerBI. Microsoft defined them as well at https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools . First things first, and you need to download and install NodeJS , in case if you do not have npm setup in your machine.  Second step is to run couple of npm commands to install Power BI Visual Tools and create & publish the cert. Finally, create your own package and upload with the help of npm. 1.       npm install -g powerbi-visuals-tools 2.       pbiviz --create-cert pbiviz --install-cert 3.       pbiviz new My Visual name – This will create the file under the name of your visual file. 4.      pbiviz start – You need to go to the folder where your custom visual  resides, and run this command. You can change a few things in your pbiviz.json file, like author, display name, icon, style etc. Finally, package your
Read more

How to fix Azure DevOps Error CS0579

Image
During build process of one ASP.NET web application in Azure DevOps environment, I face the error  CS0579 multiple times. Everything looks great to me, but continuous crappy error keep saying issues in AssemblyInfo.cs file. Below are few red error I have face during setup this project. "SharePointServicesWebApp\Properties\AssemblyInfo.cs(8,12): Error CS0579: Duplicate 'AssemblyTitle' attribute" ##[error]SharePointServicesWebApp\Properties\AssemblyInfo.cs(9,12): Error CS0579: Duplicate 'AssemblyDescription' attribute ##[error]SharePointServicesWebApp\Properties\AssemblyInfo.cs(10,12): Error CS0579: Duplicate 'AssemblyConfiguration' attribute ##[error]SharePointServicesWebApp\Properties\AssemblyInfo.cs(11,12): Error CS0579: Duplicate 'AssemblyCompany' attribute I was quite sure there is something coming up during build process and make this as duplicate. Because this build process also provides assembly information other way rou
Read more