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
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
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
Very Nice explanation. Good for power bi learning. Hope many good videos come about power bi
Thanks for sharing
Your way of explanation is very nice....it sounds good...plz explain DAX all Functions and operators in detail tq
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.
VERY USEFUL THANK YOU!!
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.
Meri Pyaari Bindu... Great job
It is a good explanation .It is you solve my doubt
Excellent akka✌
Great 👍
Nice work
Good information
You should do a video on it...That will help alot.
Wow!! someone provided the answers of my question, which I was looking for many days. Thank you new subscriber on!!!
@TheHimaBindu
3 жыл бұрын
Thank you 😊
Nice explanation
Explained very clearly ..Thank you.
@TheHimaBindu
3 жыл бұрын
Thank you
Awesome explain
@TheHimaBindu
3 жыл бұрын
Thank you
#Ur_Videos_always_helpful_Thank_you
Thank you maa'm
nice
Tq mam
Nice try to do more videos and please do videos on sql
Tq🌹🌹🌹
Please do one vedio on how to explain project in an interview
Hello Bindu, Nice explanation and sounds good. I want to know how to make connection from Power BI report to power BI partner showcase.
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.
Hi bindu your way of Explanation is very nice
@TheHimaBindu
3 жыл бұрын
Thank you
👌👍
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.
Bindugaru Your explain the sub , really it's nice
@TheHimaBindu
2 жыл бұрын
Thank you Suneetha 😊
Fantastic info mamm 🙏
@TheHimaBindu
2 жыл бұрын
Thank you
Voice is low here but you have describe d very well
Explained so good.. Thank you 👍
@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
2 жыл бұрын
@Dash Theo Instablaster =)
@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
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
2 жыл бұрын
@Dash Theo no problem xD
Please post some more videos for real time querries answers same explanation
excellent explanation
@TheHimaBindu
3 жыл бұрын
Thank you
@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
3 жыл бұрын
Sure. Will try to do some interview question videos
@nagendrababu5740
3 жыл бұрын
@@TheHimaBindu Thanks for supporting public
Hi hima can we see some practicals Thank you in advanct
Is Live mode connectivity available in power bi? So many interviewer asking about different between direct mode vs live. Can you explain
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 ?
can you explain about connect live ?
Explain Virtual relationships
Madam can u tell me, future and growth and package in power Bi..
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
2 жыл бұрын
Hi Aparna . No it won't effect the source
Hello Mam I have some doubts and need some clarification on Power BI gateway.
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.
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?
But with the latest version, you can extract data from more than one data source even if u use direct quey
Madam Can we create Table , Measure, Column in Import mode
Hai bindhu... Pls do video on parameters...
@TheHimaBindu
3 жыл бұрын
Will do
@kusaanjireddy5563
3 жыл бұрын
@@TheHimaBindu where are you from
Sql lo eanni queries use autaye bindu garu power Bi use chese tapudu koncham idea ivandi
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
2 жыл бұрын
Could u please respond... Mam
@TheHimaBindu
2 жыл бұрын
Hi . If your dataset is greater than 1gb for pro account it wont let you add it. It wont upload it partially.
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.
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
2 жыл бұрын
Direct Query
Hi How many days lear in power bi
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!
Could you please explain with practice.
Could you explain live connection
@TheHimaBindu
2 жыл бұрын
Will do
Hi Bindu garu
@geethareddy528
3 жыл бұрын
Can please tell me difference between all and all functuon
Do power bi need a very good communication skills?
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
3 жыл бұрын
Perfect. Thnx
To summarize it, when do you use Direct Query over Import?
Hello i am housewife Wanted to learn power bi Can u tell me prerequisites to start power bi
@vijayparsai7291
3 жыл бұрын
Start from MSBI and SSBI then switch to power bi
@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
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
3 жыл бұрын
Will do. Thank you
SUNILMOTWANI
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
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
3 жыл бұрын
Will do. Thank you for watching my videos
Now I understand why people prefer Tableau. 😶 #MicrosoftPricingSucks.
Live Recorded Power Bi Interview With TCS [2021] :- kzread.info/dash/bejne/gIiNwZmDqNrcmZc.html
:/ she is beautiful
@TheHimaBindu
2 жыл бұрын
Thank you !
@yogibobj6979
2 жыл бұрын
@@TheHimaBindu
Nice explanation
Hi Bindu garu
@TheHimaBindu
3 жыл бұрын
Hi