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