Creation of Tables / Model when you import from Excel

[npowerbi]

Hi Team,

I am new to Power BI and need a recommendation in one scenario. I have got an excel spreadsheet with one large table and may have redundancies. This can not change. When I start with Power BI and import this spreadsheet, it creates replica as a one table Power BI.

How do we create a model out of one table in Power BI or do we generally continue with the dataset the way it is imported from Excel?

Should the workflow be like this?

1. Import the spreadsheet data in Power BI as a one table

2. Create additional tables or a model in Power BI (Star Schema)

3. Establish relationships

4. Develop visualizations

What is the recommended way or practice? Looking for recommendations and preferably samples

Thanks

[v-piga-msft · Accepted solution]

Hi @npowerbi,

From my understand, the work flow in Power BI Desktop should be like this:

1. Get Data —— select the data source 

2. Click Edit and go to Power Query Editor, you could transform and clean data, create a model.

3. Apply & Close, go to Relationship view and create relationships between tables.

4. After creating the data model, you could go to Report view and create the visualizations.

For more details about each step, you could have a good look at this document.

Best Regards,

Cherry