Forum Discussion
Helper IOne huge dataset or several datasets ? Raw data or preprocessed data ?
Super UserHello François ,
1- You could start first by developing a star schema data Model for better performance.
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
2- As long as you can do the data transformation in the data source, don't fo it in the report.
3- you could do the dataset in one power bi file and then open new files that connects to Power bi dataset.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Helper IThanks for your quick answer !
About 1/, after reading a bit about the star schema, I can see that it's what we were doing in most of our reports already. In this specific case, I think we are more in a "constellation" case than a simple star one : I have multiples stars (one around sales, one around CRM activities, one around quotes), and they share the same dimension tables. To connect the dimension tables together is what we would like to do : you filter on one dimension, it filters on multiple stars. I don't know if that's something easily doable in Power BI, or even if that's the perfect tool for that. What I'm asked for could be more the job of a CDP tool than a job for PowerBI.
For 2/, noted, we will work on the data first and not let PowerBI do all the job
For 3/, that's what I meant by "virtual tables", it's something we were already doing to avoid importing the same data in multiple datasets.