SQL Database with Power BI

I need to have a demo how to make CSV file containing product data that needs to live in SQL Server.

With sample data by your own, first task is to design and build a clean, well-indexed schema, then import the file. In addition to the product table, I also need relationships that let me tie in customer master and sales detail tables, so please create those structures and wire up the foreign keys accordingly.

Once the data model is sound, connect it to Power BI. I want the connection set up (DirectQuery or import—whichever performs best for this volume) and a quick sample report that proves the joins are working.

Deliverables
• SQL Server schema (tables, keys, indexes)
• ETL script or SSIS/Power Query steps that load the CSV
• Added customer master and sales detail tables with working relationships
• Verified Power BI file (*.pbix) connected to the database and showing a test report
• Brief hand-off notes so I can refresh or extend the model on my own

I’m on SQL Server developer edition and the latest Power BI Desktop. If you have questions about data types, naming conventions, or performance tweaks, let’s discuss them early so the build goes smoothly.