Q: How do you import data from various sources (Excel, SQL Server, CSV) into Power BI?

A: Here’s how to handle multi-source imports in Power BI Desktop:

1. Excel:

° Go to Home > Get Data > Excel

° Select your file & sheets or tables



2. CSV:

° Choose Get Data > Text/CSV

° Browse and load the file



3. SQL Server:

° Select Get Data > SQL Server

° Enter server/database name

° Use a query or select tables directly



4. Combine Sources:

° Use Power Query to transform, merge, or append tables

° Create relationships in the Model view


Pro Tip:
Use consistent data types and naming to make transformations smoother across sources!