NeoSOFT Power BI Developer Interview Questions and Answers

Power BI offers three storage modes: Import, DirectQuery, and Composite, each serving different data handling needs.

• Import Mode: Data is imported into Power BI, allowing for fast performance and rich data modeling. Example: Loading sales data from Excel.

• DirectQuery Mode: Data remains in the source system, allowing real-time queries. Example: Connecting to a SQL Server database for live data.

• Composite Mode: Combines bot...read more

Drill through allows users to navigate to detailed reports, while drill down enables viewing data at a more granular level.

• Drill down: View data hierarchically, e.g., from yearly sales to quarterly sales.

• Drill through: Navigate to a different report for detailed insights, e.g., clicking on a product to see its sales report.

• Drill down is typically within the same visual, while drill through opens a new report or page.

• Dr...read more

DataWindow is a GUI control in PowerBuilder used to display and manipulate data from a database.

• DataWindow can be used to retrieve data from a database, display it in a tabular format, and allow users to edit the data.

• It supports various data sources such as SQL, ODBC, and XML.

• DataWindow can also be used to create reports and graphs.

• It provides various features such as sorting, filtering, grouping, and computed columns...read more