TCS Power BI Developer Interview Questions and Answers

Q1. Difference between import and direct query
Ans. 
Import brings data into Power BI for processing, while direct query connects to data source live for real-time analysis.
• Import: Data is imported into Power BI for processing and analysis.

• Direct Query: Connects to data source live for real-time analysis without importing data.

• Import is suitable for smaller datasets, while direct query is better for large datasets or real-time analysis.

• Imported data is stored in Power BI...read more
Answered by AI
Add your answer

Q1. Types of Joins in Power Query editor.
Ans. 
There are four types of joins in Power Query editor: Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join.
• Inner Join combines rows from two tables based on a matching column.

• Left Outer Join returns all rows from the left table and the matching rows from the right table.

• Right Outer Join returns all rows from the right table and the matching rows from the left table.

• Full Outer Join returns all rows from bot
Answered by AI
Add your answer
Q2. Types of transformations performed in Power QUERY EDITOR
Ans. 
Power Query Editor allows various transformations on data such as filtering, sorting, merging, splitting, and aggregating.
• Filtering: Removing rows based on certain criteria.

• Sorting: Arranging rows in a specific order.

• Merging: Combining multiple tables or queries into one.

• Splitting: Dividing a column into multiple columns.

• Aggregating: Calculating summary statistics like sum, average, count, etc.
Answered by AI
Add your answer

Power BI and SQL Coding

Q1. Salary discussion ........ TCS offer very low salary as per market standards
Add your answer
Q2. Normal Question like your family background
Add your answer
Q3. SQL and PLSQL Question
Add your answer
Q4. BI Question for RLS
Add your answer
Q5. MS Azure automation Question
Add your answer

Q1. Dimension modelling
Add your answer