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

Пікірлер: 104

  • @vickyprince7848
    @vickyprince78483 жыл бұрын

    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

  • @vishnupp5944
    @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

  • @narendrakishore8526
    @narendrakishore85262 жыл бұрын

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

  • @optionsregularincomefamily692
    @optionsregularincomefamily6923 жыл бұрын

    Thanks for sharing

  • @vickyprince7848
    @vickyprince78483 жыл бұрын

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

  • @bibekanandabhattacharjee952
    @bibekanandabhattacharjee9522 жыл бұрын

    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.

  • @shreyamukkawar2989
    @shreyamukkawar29892 жыл бұрын

    VERY USEFUL THANK YOU!!

  • @AB-hs9pw
    @AB-hs9pw2 жыл бұрын

    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.

  • @ubiquitous1212
    @ubiquitous1212 Жыл бұрын

    Meri Pyaari Bindu... Great job

  • @tagessemengiste8556
    @tagessemengiste85565 ай бұрын

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

  • @akshayachandrasekar8285
    @akshayachandrasekar82852 жыл бұрын

    Excellent akka✌

  • @nazmulhaque3894
    @nazmulhaque38942 жыл бұрын

    Great 👍

  • @sujit9916
    @sujit99163 жыл бұрын

    Nice work

  • @RaMeShBaBu-gf1wc
    @RaMeShBaBu-gf1wc2 жыл бұрын

    Good information

  • @shrikantlandage7305
    @shrikantlandage73053 жыл бұрын

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

  • @AmanKumar-pe3ub
    @AmanKumar-pe3ub3 жыл бұрын

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

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Thank you 😊

  • @narendrakishore8526
    @narendrakishore85262 жыл бұрын

    Nice explanation

  • @jaipal007
    @jaipal0073 жыл бұрын

    Explained very clearly ..Thank you.

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Thank you

  • @vijayparsai7291
    @vijayparsai72913 жыл бұрын

    Awesome explain

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Thank you

  • @princemurali5509
    @princemurali55092 жыл бұрын

    #Ur_Videos_always_helpful_Thank_you

  • @thalisafari8144
    @thalisafari814410 ай бұрын

    Thank you maa'm

  • @cnu9948
    @cnu99483 жыл бұрын

    nice

  • @Vinu8143
    @Vinu81433 жыл бұрын

    Tq mam

  • @sandeepsandy5286
    @sandeepsandy52862 жыл бұрын

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

  • @BTECH123
    @BTECH1232 жыл бұрын

    Tq🌹🌹🌹

  • @kesava9538
    @kesava95383 жыл бұрын

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

  • @knowledgepark4158
    @knowledgepark41583 жыл бұрын

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

  • @vasisultan8896
    @vasisultan88963 жыл бұрын

    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.

  • @kesava9538
    @kesava95383 жыл бұрын

    Hi bindu your way of Explanation is very nice

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Thank you

  • @aiinabox1260
    @aiinabox12602 жыл бұрын

    👌👍

  • @ansumanbehera8150
    @ansumanbehera81502 жыл бұрын

    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.

  • @mandalapusuneetha4960
    @mandalapusuneetha49602 жыл бұрын

    Bindugaru Your explain the sub , really it's nice

  • @TheHimaBindu

    @TheHimaBindu

    2 жыл бұрын

    Thank you Suneetha 😊

  • @saketsrivastava84
    @saketsrivastava842 жыл бұрын

    Fantastic info mamm 🙏

  • @TheHimaBindu

    @TheHimaBindu

    2 жыл бұрын

    Thank you

  • @tecnilogics6376
    @tecnilogics63762 жыл бұрын

    Voice is low here but you have describe d very well

  • @vishnurao2901
    @vishnurao29013 жыл бұрын

    Explained so good.. Thank you 👍

  • @dashtheo5741

    @dashtheo5741

    2 жыл бұрын

    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

    @judsonkenneth2854

    2 жыл бұрын

    @Dash Theo Instablaster =)

  • @dashtheo5741

    @dashtheo5741

    2 жыл бұрын

    @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

    @dashtheo5741

    2 жыл бұрын

    @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

    @judsonkenneth2854

    2 жыл бұрын

    @Dash Theo no problem xD

  • @RaMeShBaBu-gf1wc
    @RaMeShBaBu-gf1wc2 жыл бұрын

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

  • @nagendrababu5740
    @nagendrababu57403 жыл бұрын

    excellent explanation

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Thank you

  • @nagendrababu5740

    @nagendrababu5740

    3 жыл бұрын

    @@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

    @TheHimaBindu

    3 жыл бұрын

    Sure. Will try to do some interview question videos

  • @nagendrababu5740

    @nagendrababu5740

    3 жыл бұрын

    @@TheHimaBindu Thanks for supporting public

  • @gopalb7954
    @gopalb79543 жыл бұрын

    Hi hima can we see some practicals Thank you in advanct

  • @mr.blocky_boys5358
    @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

  • @pravinmandlekar5732
    @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 ?

  • @yaswanthkumar9997
    @yaswanthkumar99972 жыл бұрын

    can you explain about connect live ?

  • @RajuMokka
    @RajuMokka2 жыл бұрын

    Explain Virtual relationships

  • @Ram-vg5dt
    @Ram-vg5dt2 жыл бұрын

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

  • @aparnasinha2914
    @aparnasinha29142 жыл бұрын

    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

    @TheHimaBindu

    2 жыл бұрын

    Hi Aparna . No it won't effect the source

  • @pankajkishore2257
    @pankajkishore22572 жыл бұрын

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

  • @kiran4059
    @kiran40592 жыл бұрын

    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.

  • @akshaypatil8155
    @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
    @aiinabox12602 жыл бұрын

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

  • @anilgondi1008
    @anilgondi1008 Жыл бұрын

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

  • @kusaanjireddy5563
    @kusaanjireddy55633 жыл бұрын

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

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Will do

  • @kusaanjireddy5563

    @kusaanjireddy5563

    3 жыл бұрын

    @@TheHimaBindu where are you from

  • @Sathya27
    @Sathya272 жыл бұрын

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

  • @bandarisahithikiran4824
    @bandarisahithikiran48242 жыл бұрын

    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

    @bandarisahithikiran4824

    2 жыл бұрын

    Could u please respond... Mam

  • @TheHimaBindu

    @TheHimaBindu

    2 жыл бұрын

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

  • @nareshe9906
    @nareshe99062 жыл бұрын

    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.

  • @harshindublin
    @harshindublin2 жыл бұрын

    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

    @rajasekharpasam7882

    2 жыл бұрын

    Direct Query

  • @hibye8383
    @hibye8383 Жыл бұрын

    Hi How many days lear in power bi

  • @sparvathaneni1
    @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!

  • @tulsidaslodhi5300
    @tulsidaslodhi53002 жыл бұрын

    Could you please explain with practice.

  • @Sathya27
    @Sathya272 жыл бұрын

    Could you explain live connection

  • @TheHimaBindu

    @TheHimaBindu

    2 жыл бұрын

    Will do

  • @geethareddy528
    @geethareddy5283 жыл бұрын

    Hi Bindu garu

  • @geethareddy528

    @geethareddy528

    3 жыл бұрын

    Can please tell me difference between all and all functuon

  • @smileysravzzz9261
    @smileysravzzz92613 жыл бұрын

    Do power bi need a very good communication skills?

  • @devopsworld8357
    @devopsworld83573 жыл бұрын

    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

    @TheHimaBindu

    3 жыл бұрын

    Perfect. Thnx

  • @user-re5uv2mm2h
    @user-re5uv2mm2h Жыл бұрын

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

  • @smileysravzzz9261
    @smileysravzzz92613 жыл бұрын

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

  • @vijayparsai7291

    @vijayparsai7291

    3 жыл бұрын

    Start from MSBI and SSBI then switch to power bi

  • @devopsworld8357

    @devopsworld8357

    3 жыл бұрын

    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

  • @RakeshKumar-bu9xg
    @RakeshKumar-bu9xg3 жыл бұрын

    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

    @TheHimaBindu

    3 жыл бұрын

    Will do. Thank you

  • @sunilmotwani8982
    @sunilmotwani89822 жыл бұрын

    SUNILMOTWANI

  • @zuhebkhan6973
    @zuhebkhan69733 жыл бұрын

    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
    @vickyprince78483 жыл бұрын

    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

    @TheHimaBindu

    3 жыл бұрын

    Will do. Thank you for watching my videos

  • @gjsanu
    @gjsanu2 жыл бұрын

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

  • @deepanpatel8110
    @deepanpatel81102 жыл бұрын

    Live Recorded Power Bi Interview With TCS [2021] :- kzread.info/dash/bejne/gIiNwZmDqNrcmZc.html

  • @yogibobj6979
    @yogibobj69792 жыл бұрын

    :/ she is beautiful

  • @TheHimaBindu

    @TheHimaBindu

    2 жыл бұрын

    Thank you !

  • @yogibobj6979

    @yogibobj6979

    2 жыл бұрын

    @@TheHimaBindu

  • @shaikazeem8443
    @shaikazeem84432 жыл бұрын

    Nice explanation

  • @geethareddy528
    @geethareddy5283 жыл бұрын

    Hi Bindu garu

  • @TheHimaBindu

    @TheHimaBindu

    3 жыл бұрын

    Hi

Келесі