Forum Discussion
Super beginner question: how do you use a single data source?
Hi Everyone, I'm sorry to post such a basic question but for the life of me I cannot get any results via google or on stackoverflow about what I'm trying to do, which is use a single dat...
You can use a single flat table for simple datasets, but it is not considered best practice and it will definitely make the DAX harder with more complex datasets.
Ideally you should aim for a star schema, as I covered here https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
You can create this using power query on data load. Just connect to the sheet, import the data and then set that table so it doesn’t load “right click, turn off enable load”. Then you create a data table and lookup tables from there, “right click, reference”