Awesome work bro, please keep posting all the topic from Fabric... appreciate your efforts
@AmitChandak Жыл бұрын
Thanks 🙏. Hope you will like the series Mastering Microsoft Fabric 30 Videos: kzbin.info/www/bejne/pl7ZYXxriJKsmNU
@sonalimishra3356 Жыл бұрын
Really appreciate for your efforts, need more videos on ms fabric
@AmitChandak Жыл бұрын
@sonalimishra3356 Thanks 🙏. Hope you will like the full series, added 37 Videos so far. Mastering Microsoft Fabric 35+ Videos: kzbin.info/www/bejne/pl7ZYXxriJKsmNU
@123jamalq Жыл бұрын
Sir, It is really a challenge task and u did effectively.
@AmitChandak Жыл бұрын
Thanks.
@mohitpande2006Ай бұрын
Hi Amit, Thank for the video, I have question how can we upload PDF or GIF file in SQL serve in fabric env. I can convert pdf to base64 and then upload it into sql but if I upload pdf straight is their any way.
@nitesh791102 Жыл бұрын
Hi Amit, I tried connecting Dataverse table to Lakehouse using data pipeline. But the pipeline does not respond. Can you please suggest/guide on how to do this.
@AmitChandak Жыл бұрын
I will check and get back
@prashantsuthar7 Жыл бұрын
Work for me thanks 👍
@AmitChandak Жыл бұрын
You're welcome! 🙏 Hope You will like the series - kzbin.info/www/bejne/pl7ZYXxriJKsmNU Please find 370+ videos, blogs, and files in 70+ hours of content in the form of an organized course. Get Fabricated with Microsoft Fabric, Power BI, SQL, Power Query, DAX Please Like and Share biworld.graphy.com/courses/Get-Fabricated-Learn-Microsoft-Fabric-Power-BI-SQL-Power-Query-DAX-Dataflow-Gen2-Data-Pipeline-from-Amit-Chandak-649506b9e4b06f333017b4f5
@GauravShukla-ut2xs Жыл бұрын
Hi, I am not able to understand the step where you talked about connecting sql server to Microsoft fabric. Could you please elaborate that step to me. When i launched ssms, which option should I choose to login and where will I get the option to enter my email and password. Thanks a lot.
@AmitChandak Жыл бұрын
check if this screenshot can help www.dropbox.com/s/gc10aca0ohecwvh/Login%20to%20SQL%20Server.PNG?dl=0
@AmitChandak Жыл бұрын
SQL Server Authentication will give both user and password
@uplifthabesha754 Жыл бұрын
What is the difference between loading data using pipeline and gen 2?
@AmitChandak Жыл бұрын
Dataflow Gen 2, a component of Microsoft Fabric(Came from Power BI world -> Powe Query), offers intuitive data transformation capabilities. Data Engineers can use Dataflow to visually design and execute data transformations without the need for complex coding, reducing development time and increasing productivity. And can finally load data to Lakehouse and Warehouse Data Pipeline can be used to load data. It can also be used to orchestrate and monitor end-to-end. I can call dataflow, spark job in the data pipeline refer learn.microsoft.com/en-us/fabric/data-factory/data-factory-overview#data-pipelines
@arfanislamabir5 ай бұрын
I am getting data type issue while mapping. Can you please check the recent update ?
@AmitChandak5 ай бұрын
@@arfanislamabir , please check all columns have fixed data types, no mixed one. Also you can correct it mapping, location has moved to right
@balajidevaraj7167 Жыл бұрын
Hi I tried to load the data from Azure SQL to this Data warehouse, but in the choose destination, its not showing my data warehouse name. could you please help me on this
@AmitChandak Жыл бұрын
You already created warehouse? It should warehouse in destination option. I will also check Azure SQL and come back.
@balajidevaraj7167 Жыл бұрын
@@AmitChandak yes. I created warehouse and from there only using pipeline I'm trying to load the data into warehouse
@AmitChandak Жыл бұрын
I was able to do so. I will create a video and share.
@balajidevaraj7167 Жыл бұрын
@@AmitChandak I tried to load the data from LH but there also DW destination is not visible. Not sure if i am missing anything when loading data into DW
@AmitChandak Жыл бұрын
Please find the Video- kzbin.info/www/bejne/aqjNZZVpett5pqs
@sanumpzha Жыл бұрын
Hi Amit, i followed the steps and i couldnt load the table as the _id column BIGINT data type error. I tried in SSMS as well but still..
@AmitChandak Жыл бұрын
In the pipeline on the mapping step(which is now part of the popup) , make sure you have changed the data type. Also, make sure ID is a whole number. Please share the error you are getting. Thanks 🙏
@sanumpzha Жыл бұрын
@@AmitChandak Here is the error. ErrorCode=UserErrorSqlDWCopyCommandError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=SQL DW Copy Command operation failed with error 'Column 'customer_id' of type 'BIGINT' is not compatible with external data type 'Parquet physical type: BYTE_ARRAY, logical type: UTF8', please try with 'VARCHAR(8000)'
@suprajamuppana23005 ай бұрын
Did this error get solved.? I have been facing same error
@sudharsankalyanakumar63202 ай бұрын
@@suprajamuppana2300 : Is it resolved
@saumyakapoor6772 Жыл бұрын
Thank you for your videos. They are very informative. I am not able create a new data pipeline in the warehouse. When I click on it, I do not get any error but new pipeline window does not open. Kindly suggest
@AmitChandak Жыл бұрын
Clear browser cache, refresh and try again. I am able to open a new pipeline. If it does not open, let me know.
@saumyakapoor6772 Жыл бұрын
@@AmitChandak no luck
@saumyakapoor6772 Жыл бұрын
I can directly create a pipeline from data factory, but not from the get data option in warehouse
@bhumikaattarde1827 Жыл бұрын
i tried loading data from lakehouse to warehouse via pipeline, but at the connect to data destination step, the data type column is not having drop down option to change data type. so not able to change the data type of column at this step. can you help me?
@AmitChandak Жыл бұрын
I such case create a table before hand with required data type and try to load into that. Thanks. Hope you will like the full series kzbin.info/www/bejne/pl7ZYXxriJKsmNU
@prinkilduhoon Жыл бұрын
What is think about PL 300 Microsoft power BI certificate It is worth it
@AmitChandak Жыл бұрын
Yes, Power bi will still hold good. Hope to see some new certificates for fabric in near future.
@thghtfl Жыл бұрын
I still can not believe this warehouse doesn't support Postgres in the cloud as a source
@AmitChandak Жыл бұрын
I have checked again that the pipeline is compatible with both PostgreSQL and Azure Database for PostgreSQL,. PostgreSQL should support for cloud environments. Similarly, Dataflow Gen2 is also supporting these databases.