Difference between Direct Query and Import in Power BI | Power BI Interview Question

This Video talks about
Power BI Interview Questions and answers
Difference between Direct Query and Import in Power BI
What is Direct query in power bi
what is import in power bi
Power BI Interview Questions and answers for experienced
power bi interview questions
powerbi
interview questions and answers
power bi answers
connect power bi directly with sql
power bi tutorial for beginners
#powerbi #powerbidesktop #powerbitips #powerbiinterviewquestions #interview
#import #directquery

[@vickyprince7848]

Thanks for quick reply Madam....Sure i will follow all concepts what ever you are explaining......Waiting to watch all DAX concepts from you....Thank you

[@narendrakishore8526]

Very Nice explanation. Good for power bi learning. Hope many good videos come about power bi

[@vishnupp5944]

Thanks for the video. I am happy to tell you that i could answer this question in my interview today. I had a glance of your video and did not give much importance then, but it became small game changer now. Thanks

[@optionsregularincomefamily692]

Thanks for sharing

[@vickyprince7848]

Your way of explanation is very nice....it sounds good...plz explain DAX all Functions and operators in detail tq

[@sujit9916]

Nice work

[@bibekanandabhattacharjee952]

This video is well explained @The Hima Bindu , Keep it up. I think like me others are looking forward to more quality videos from you.

[@nazmulhaque3894]

Great 👍

[@tagessemengiste8556]

It is a good explanation .It is you solve my doubt

[@RaMeShBaBu-gf1wc]

Good information

[@shreyamukkawar2989]

VERY USEFUL THANK YOU!!

[@AB-hs9pw]

Hi, Bindu very good explanation about the direct query in power bi. From the background I guess you must be making this video from Canada or USA if I’m not wrong. Please make videos at least a week if possible so that we can follow your videos continuously.

[@akshayachandrasekar8285]

Excellent akka✌

[@narendrakishore8526]

Nice explanation

[@ubiquitous1212]

Meri Pyaari Bindu... Great job

[@shrikantlandage7305]

You should do a video on it...That will help alot.

[@sandeepsandy5286]

Nice try to do more videos and please do videos on sql

[@cnu9948]

nice

[@princemurali5509]

#Ur_Videos_always_helpful_Thank_you

[@vasisultan8896]

Hi, Could you please suggest if it is possible to create calculate columns and measures and Direct Query Mode? We can't actually see data in Power BI while connecting using Direct Query Mode, so how is it possible to create a calculated column? Also please can you suggest regarding Calculated Measures.

[@AmanKumar-pe3ub]

Wow!! someone provided the answers of my question, which I was looking for many days. Thank you new subscriber on!!!

[@TheHimaBindu]

Thank you 😊

[@jaipal007]

Explained very clearly ..Thank you.

[@TheHimaBindu]

Thank you

[@kesava9538]

Please do one vedio on how to explain project in an interview

[@knowledgepark4158]

Hello Bindu, Nice explanation and sounds good. I want to know how to make connection from Power BI report to power BI partner showcase.

[@vijayparsai7291]

Awesome explain

[@TheHimaBindu]

Thank you

[@kiran4059]

Hi Can we get an Updated Data if we choose Import and connects Sql server by doing the clicking on refresh button in power query/power view.

[@thalisafari8144]

Thank you maa'm

[@pravinmandlekar5732]

Hi You missed to highlight one point is what happen on data refresh in both cases. Direct and Import option ? If i want to have latest data in report which option is better ?

[@ansumanbehera8150]

Appreciate your good work and content. It's really helpful and also few things were clear about Import mode. One request if you can explain about one option available under options for Direct Query - Treat SAP HANA as a relational source. It will be helpful. It is said that in relational mode, percentage or aggregation doesn't work properly given the sync of data match between the source and Power BI.

[@kesava9538]

Hi bindu your way of Explanation is very nice

[@TheHimaBindu]

Thank you

[@pankajkishore2257]

Hello Mam I have some doubts and need some clarification on Power BI gateway.

[@Vinu8143]

Tq mam

[@mandalapusuneetha4960]

Bindugaru Your explain the sub , really it's nice

[@TheHimaBindu]

Thank you Suneetha 😊

[@RaMeShBaBu-gf1wc]

Please post some more videos for real time querries answers same explanation

[@mr.blocky_boys5358]

Is Live mode connectivity available in power bi? So many interviewer asking about different between direct mode vs live. Can you explain

[@Sathya27]

Sql lo eanni queries use autaye bindu garu power Bi use chese tapudu koncham idea ivandi

[@BTECH123]

Tq🌹🌹🌹

[@tecnilogics6376]

Voice is low here but you have describe d very well

[@Ram-vg5dt]

Madam can u tell me, future and growth and package in power Bi..

[@akshaypatil8155]

Hi Hima, when we get data and then we choose transform button, it opens the power query. This also means that data is not present in the power BI, right? How it is different from Direct query?

[@aiinabox1260]

👌👍

[@sparvathaneni1]

Hi Bindu, I have 10 Million rows in my data set, How do I make sure power bi service extract the data for me ? How do you handle these import process in power bi? Any inputs is greatly appreciated. Thank you!

[@gopalb7954]

Hi hima can we see some practicals Thank you in advanct

[@nareshe9906]

I want to implement caching in power BI please suggest how can I do the same. If you have any video's please share the link.

[@saketsrivastava84]

Fantastic info mamm 🙏

[@TheHimaBindu]

Thank you

[@anilgondi1008]

Madam Can we create Table , Measure, Column in Import mode

[@aiinabox1260]

But with the latest version, you can extract data from more than one data source even if u use direct quey

[@yaswanthkumar9997]

can you explain about connect live ?

[@vishnurao2901]

Explained so good.. Thank you 👍

[@dashtheo5741]

sorry to be so off topic but does anybody know of a tool to log back into an instagram account? I somehow forgot my password. I would appreciate any help you can offer me

[@judsonkenneth2854]

@Dash Theo Instablaster =)

[@dashtheo5741]

@Judson Kenneth thanks so much for your reply. I got to the site on google and Im waiting for the hacking stuff atm. Takes quite some time so I will get back to you later with my results.

[@dashtheo5741]

@Judson Kenneth It did the trick and I now got access to my account again. I'm so happy! Thanks so much you saved my account :D

[@judsonkenneth2854]

@Dash Theo no problem xD

[@RajuMokka]

Explain Virtual relationships

[@harshindublin]

I need real-time data for my reports that is connected to sql server. Which would be best option amongst Import and direct query mode considering schedule refresh

[@rajasekharpasam7882]

Direct Query

[@aparnasinha2914]

Hi Bindu . Awesome explanation .I have a question when we do direct query or live connection and do modelling of data does it effect original data source?

[@TheHimaBindu]

Hi Aparna . No it won't effect the source

[@nagendrababu5740]

excellent explanation

[@TheHimaBindu]

Thank you

[@nagendrababu5740]

@@TheHimaBindu mam can u explain interview point of questions power desktop, power service,dax mam .. I am requesting you..I am the follower of ur channel

[@TheHimaBindu]

Sure. Will try to do some interview question videos

[@nagendrababu5740]

@@TheHimaBindu Thanks for supporting public

[@tulsidaslodhi5300]

Could you please explain with practice.

[@hibye8383]

Hi How many days lear in power bi

[@kusaanjireddy5563]

Hai bindhu... Pls do video on parameters...

[@TheHimaBindu]

Will do

[@kusaanjireddy5563]

@@TheHimaBindu where are you from

[@smileysravzzz9261]

Do power bi need a very good communication skills?

[@bandarisahithikiran4824]

Hi... Bindu.. thanks for very short and clear explanation... And i have a question.. What will happen if i try to import more than 1 GB data in pro account.. will it throw error or will it import partially... Kindly let me know ..

[@bandarisahithikiran4824]

Could u please respond... Mam

[@TheHimaBindu]

Hi . If your dataset is greater than 1gb for pro account it wont let you add it. It wont upload it partially.

[@devopsworld8357]

Hey Hima Bindu.. I think you missed this point While using Direct Query in Power BI Desktop SQL Server as a data Sourcd , What ever changes you made at DB level will reflect ASAP when you hit refresh . Where as when you choose Import as an option for SQL Server Data source level it will not reflect any changes you did ..Plz Correct me if I'm wrong

[@TheHimaBindu]

Perfect. Thnx

[@Sathya27]

Could you explain live connection

[@TheHimaBindu]

Will do

[@user-re5uv2mm2h]

To summarize it, when do you use Direct Query over Import?

[@RakeshKumar-bu9xg]

Hi Bindu, thank you for explaining Import and direct query so nicely. When I visited in data model view > clicked on a table > Properties > Advanced > I found "Import", "Direct Query" and "Dual". You explained Import, Direct Query but not mentioned anything about dual options. Kindly throw some light on dual option please.

[@TheHimaBindu]

Will do. Thank you

[@zuhebkhan6973]

Hi Ma'am ...my self Zuheb..I have Send you So many Comment on your wonder full work,.ma'am ...I have one challenge in preparing a DAX for my management ask below is the requirement I'm looking for, Please help me in this or make a video on the same it will great help. I have a column in my dataset name as product Working Capital - Secured Business Development- Secured Asset Purchase- Secured Working Capital - Secured Asset Purchase- Secured Working Capital - Secured Business Development- Unsecured Working Capital - Secured Working Capital - Secured Working Capital -Unsecured Asset Purchase- Secured I need only substring as Secured and Unsecured in different column Please help me in this Sir. Thanks in Advance Zuheb HS

[@vickyprince7848]

Hello Madam please explain all DAX concepts,functions and operators and its uses.........where to us DAX functions. please explain in detail tq....Waiting for your Response and to get DAX videos

[@TheHimaBindu]

Will do. Thank you for watching my videos

[@smileysravzzz9261]

Hello i am housewife Wanted to learn power bi Can u tell me prerequisites to start power bi

[@vijayparsai7291]

Start from MSBI and SSBI then switch to power bi

[@devopsworld8357]

You Should Very Good at SQL Server You Should Very Good at DWH Concepts You need to know about ETL Concepts In Short I can say very strong at SQL and DWH Concepts

[@geethareddy528]

Hi Bindu garu

[@geethareddy528]

Can please tell me difference between all and all functuon

[@gjsanu]

Now I understand why people prefer Tableau. 😶 #MicrosoftPricingSucks.

[@deepanpatel8110]

Live Recorded Power Bi Interview With TCS [2021] :- kzbin.info/www/bejne/hIW8kGqArdypn5Y

[@sunilmotwani8982]

SUNILMOTWANI

[@yogibobj6979]

:/ she is beautiful

[@TheHimaBindu]

Thank you !

[@yogibobj6979]

@@TheHimaBindu

[@shaikazeem8443]

Nice explanation

[@geethareddy528]

Hi Bindu garu

[@TheHimaBindu]

Hi