Thanks, would be really helpful if you upload the notebook on GitHub etc - that would help in practicing.

Great work Dinesh...!!!

Thanks for the explanation, could you pls share the ADF code/template?

😊ল০০ল😊০

Nice video ! From my experience, the starter pool works well without HC mode, while custom Spark pools can benefit from it. I've noticed HC mode enhances performance for heavy-load concurrent tasks, but if we are cost-conscious, it may be prudent to avoid HC mode for smaller tasks, as underutilized resources could increase CU costs.

hello and thanks for the video, can you share the code for the database sample and the SP sending email ?

Hey Dinesh, I want to create a data flow such that I can extract all the attachments having csv and or Excel format and save it in the Lake House, in the table format in Microsoft Fabric. Can you guide me how to execute this task?

Nice one. I tried this given error like this "[Open Browser Console for more detailed log - Double click to close this message] Failed to load model class 'ReportModel' from module 'powerbi-jupyter-client' Error: No version of module powerbi-jupyter-client is registered"

Nicely Explained . Do we have option of Authenticating using Service Principal (Bearer Token) in PowerBiClient ?

Nicely Explained . Do we have option of Authenticating using Service Principal (Bearer Token) in PowerBiClient ?

Can i connect and ingest the data using Java ( Json file ) upoading to Lake house ? i am not able to find any Java snippet using it , Use case is that i want to ingest data directly through my android app ( using Java ) it may be HTTP or Rest i dont mind but i want to ingest the files ( let say GPS data , or sensor data ) saved in JSON format into my Lake house in Fabric is it even possible can you please make video on it please ? ( I dont want to use Azure subscription )

good job and clarification

Hii! Thank you for this wonderful video. I am doing a similar thing in which I am consuming data from the Kafka topic and sending it to Power BI. I want to replicate the same thing that you have done to understand it. Can you please share the code or github repository link for it?

Can you show us how to config Maschine Learning Services on SQL Server 2022?

Nicely Explained . Do we have option of Authenticating using Service Principal (Bearer Token) in PowerBiClient ?

Where can I get the Table Name?

Wow, this is awesome! Did you share the code so I can get it and play with it? Thanks in advance for everything. I'm looking forward to watch all you videos. And Can you do permission in dashboard , like if you have cities and want each user to see his city only, like what we do in Power BI desktop version.!?

Hello, Thanks for this video! I'm trying to implement Push and Delete using a capability of latest SqlServer. It can call REST webservice creating MSXML2.ServerXMLHttp object using sp_OACreate/sp_OAMethod/sp_OADestroy system stored procedures. The main advantage is working directly on database where data are stored bypassing VisualStudio and a lot of unusefull complexity generated by writing, compiling source code, releasing it and so on... Calling webservices from database there is a very strange behaviour. Push methos works fine : it returns 200 as status code and I see values in realtime in my dashboards on PowerBi Service, but Delete method return 200 as status code but does not delete anything! If I delete rows on the microsoft webpage you shown in the video all rows are deleted. Do you ave any suggestion?

Hi, I have a question. You used the static access token to remove the rows, that expires in two hours I think. How can we make it dynamic? I tried registering an app in azure but I think that does not have permission. kindly let me know. Thanks.

G🩵🪈🍍😮😮😮

Hello! It's a very interesting video, thank s lot! Can you tell me if it is possible to create a push dataset and connect it to usual datasources like Oracle database?

Note. Can connect to a Direct Lake dataset in Desktop in a Live mode .Once you create the semantic model using the web editing in service, you can connect to the dataset in Live mode in the Desktop to create reports.

can I bring data from Infor data lake to microsoft fabric lakehouse and perform some transformations

Nicely explained.Thankyou

great content.

Good stuff..! 👏

These are tightly couple based approaches , if solutions need to move to another cloud provider in those cases? A new fresh investment would be required

Very Clear Explanation. Excellent!

Thank you so much

Awesomely done..thank you. If someone wants to update mail is sent in table column..just add one more step of sal action to execute query

If we want to return multiple output value from notebook then how do we get individual value into pipeline, can you please help me

Excellent explanation. Thanks!

Can I pass my SSO credentials that used to login into Power BI to make Databricks connectivity? Please confirm. Regards, Sam

Your voice and pronunciation is like kud venkat ...,

Data In Excel file 2 columns: Country-name, Flag India, 1 Netherlands, 1 Romania, 0 I have a excel file having data mentioned above storing in Azure data Lake Gen2. Requirement: I want only flag 1 data from excel using Azure data factory without using SQL server and data flow. I’m trying implement the requirements using the look up, set variable and for each activities in adf but I’m unable to find solution. Can you please give me your suggestions or ideas how to implement the pipeline in ADF.

Hi Dinesh, In creating connection in logic app and after entering the servername, database name and table name, I got an error "Could not retrieve values. login failed for user <token-identified principal>" any suggestion on how to resolve the connection issue?

Thanks for the informative video 👍

Thanks , very usefull

Are you looking for a thumbnail designer for your channel which would increase the click through rate of your videos then plz let me know. Happy to help Dinesh and btw your work is amazing

what if daily new files are added , how to control the access on them?

Why do I get network timeout when I try to list my clusters

How to set up recurring migration through queries/script from SQL server(On-premise) to Azure SQL database I need a help to sync the data on Azure SQL from SQL server(On-premise). Available recourses: 2 Database (SQL Server) on premise available on different server Azure SQL database on cloud Migration script/queries are ready to fetch data from on-premise sql server Requirements: Set up a scheduler which will run every 12 hours means two times in a day on Azure SQL. In scheduler, using migration scripts data will be fetch from the On-premise SQL server and insert into Azure SQL Database.

Thank you … this helped me a lot :)

Does this encryption type support "like" operator and wild cards for searching?

can you tell how storage is mapped when creating apache spark anywhere you mentioned use particular storage

Hi Dinesh. How can I copy the output of a lookup activity to blob storage or ADLS?

REally awesome presentation - thanks a lot!!

Hi Dinesh...Could you please create a video on different file storage formats like parquet, avro, ORC..etc., with some practical use cases

Could you also share a video on how the data is stored when we use a dedicated sql pool and a cost comparison between use of Synapse serverless,Dedicated and data bricks lakehouse

Thanks for sharing this Dinesh, this is very useful. I would like to understand more about the use of Serverless SQL pool for use as Datawarehouse and PowerBI Consumption. If we use Parquet - it doesn't support schema enforcement and comes across read-write conflicts. Could you provide a video on your analysis on use of Serverless SQL pool for BI consumption