Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I would like to create a data model for sql optima erp database in power bi. Is there a chance for help in defining the relational model and the necessary arrays so that I can avoid problems with later optimization.
For example, I suspect that it is better to extract tables to power bi, through sql queries with individual records, instead of loading entire tables from the database and then adapting them to the necessary minimum via power query.
I also want to define all the necessary tables and relationships between them at once. Does anyone have a template for such a medel and can share?
Best Regards
Sebastian
Hello @s_kula ,
You could start by creating views in sql for the data you want to use in power bi, dont import unnecessary data that you want use.
make sure to make it as a starschema, refer to this link https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
lastly, try to make as much as you can transformation in SQL rather than in Power BI for better performance.
refer to this video https://www.youtube.com/watch?v=OAlys79j81Q&t=141s
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |