Microsoft PowerBI Interview | Power BI Interview Questions | Power BI Mock Interview

This video shows a Power BI mock interview which is very close to an actual interview , It contains Questions related to Power BI Desktop , DAX , POWER QUERY , Power Bi sevice , Custom Visuals , Data flows and Power Platform.
Can you please give me a little background about yourself and the work experience you have in powerbi
What is Powerbi Desktop and Powerbi Service
What are the 3 views in POwerbi
What are the different types of filters
What is row level Security and what functions are used to implement it
How would you optimize the performance of a report in POwerbi
Can you please specify the types of relationships we have in powerbi
How can we handle many to many relationships
Can we have 2 active relationships between 2 tables , Which Dax would you use if you want to access both of the relationships
DAX
What is the difference between calendar and calendar auto ?
What is the difference between SUM and SUMX ?
What is an iterator function ?
Can you give me another example of iterator function ?
Can you mention 10 dax functions that you have used in the past ?
What is the difference between measures and Calculated column ?
What is the difference between calculate and calculate table ?
Can you please explain the purpose of cross filter ?
Powerquery
You Receive 100 different sales files with the same structure every month , How will you use them in Powerbi ?
What is the different types of data import modes in PowerBi and which mode will you use when ?
What is the difference between Append and Merge ?
What are different data sources have you connected to using POwerbi ?
What are the usual steps that you perform with your dataset to make it usuable ?
POwer Service
What is a workspace ?
What is the difference between APP and a workspace ?
Which powerbi license did you work on your project and what types of license are there ?
Can I refresh my dataset every hour with Pro license ?
Can we send an automatic email to the user in case if a particular event happens , Like if the sales for the day is greater than 5 million ?
How would you update your report every 6 hours ?
Do you need anything specific for Schedule Refresh ?
What are dataflows in Powerbi ?
What is the difference between star schema and snowflake schema
Can you mention 2 fact tables and 5 dimension tables that you have used in your project
What is the most challenging Project you have worked on
Do you have any questions for me ?
#PowerBIInterview #PowerBIInterviewquestions #Techcoach

[@shivyogi806]

First 2 minutes into video 👌...Humble request to create more advance level videos, although I haven't looked at all your videos...which I will.... Your guest clearly explains and the quality of content is amazing. Thank you

[@swatidas7069]

It's really very helpful, you all most covered all questions I will surely practice and hopefully I will also select soon

[@TechCoach]

I am glad I could help . All the very best :)

[@swatidas7069]

@@TechCoach 🙏

[@swatidas7069]

Please make another mock interviews for latest questions like custom visuals,Q&A,more dax questions and some scenario based questions along with sql, Python, excel and statistical analysis Please please please make I really needed guided videos like this to prepare well. I am preparing now interviews for data analyst and power bi developer

[@mayalokya]

Great content...loved it!! Thank you so much!!

[@ArchnaVijay]

Honestly Very informative , thankyou !

[@sagarchaurasia3342]

superb content, very clear on all the concepts. thanks

[@sakshinaik05]

Looking forward more bi interview series

[@TechCoach]

Sure Sakshi, I will upload more videos soon :)

[@ladylisa6768]

very good interview

[@TechCoach]

Thanks Lisa

[@avinashthakur-lv7jx]

Can you sir please make more video on informatica . Waiting for a video on interview preparation, how to explain real time project from scratch. Please make video on oracle more .

[@surabhijagadish5210]

Thank you

[@TechCoach]

Thanks a lot Surabhi

[@shailender104]

Looking up for more dax scenarios, Thank u

[@TechCoach]

Sure shailendra will upload it soon

[@bhargavirajan7982]

Nice

[@bhargavirajan7982]

@@TechCoach nice

[@harishssb344]

SHAILENDAR DID YOU GOT A JOUB ON POWER BI

[@ithvikaneela6918]

Almost all same questions I faced In my interview

[@LJ-jd5yy]

Just a correction, Its Use relationship function, not User

[@qqxx1601]

Sir where are you 😢😢 ? Now why you stop posting videos on SQL and Informatica . I switching my career and i found your video it really helping me since first day . But now you don't making video . ? Please reply if you have any issues so that i could know .

[@TechCoach]

Hello buddy thanks for the concern I am doing good I wish you all the very best for your career

[@qqxx1601]

@@TechCoach happy to hear from you sir . Can you please make more video on real time project work in SQL . I really waiting for more informatica video by you real time project, incremental loading like all those important in real time project .

[@maheshbabu-du5yt]

Could you please make python videos

[@TechCoach]

Sure , will work on it soon

[@sakshinaik05]

What is the diff betn content and app in bi?

[@borisev1097]

the function is USERELATIONSHIP, not USERRELATIONSHIP

[@TechCoach]

Thats correct Boris, it's userelationship.

[@ngfun6097]

Drill down not drillthrough

[@MyOprime]

Drill Through Answer is wrong

[@mangeshmujumdar6488]

She gives drill down answer instead of drill through

[@ranjitdhavale4061]

right