Forum Discussion
Data modelling best practices
Hello there, I'm in the middle of a process which envolves data modelling, so I start to create some queries (the metrics for the dashboard) inside of the database, then I import the data inside...
Hi Anonymous
I do all my data prep in Power Query and Dataflows, it gives me the ability to use one ( M ) language to manipulate all data no matter where it comes from, and I find it a lot easier and faster than using SQL for instance.
but I guess it always will a question of what project I'm working on, what's an easier option or simply personal preference.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
HI Anonymous ,
Since power bi data model are stored as AS tabular model, you can also take a look at AS tabular modeling related documents to know how to optimize its performance:
Regards,
Xiaoxin Sheng