Hello all, I am building a ad-hoc reporting template and i have more than 30 views in database from where users would be able to pull up any field in report. In most of the tables, i have a common primary key column that i will use for joining. Now question is, what works best in PBI provided my data is taking more than an hour to load from power query to model. I want to create the best possible data model so that users do not face timing issue while creating their report. I understand, the following sce 1 would be the best, but with 30 Dim and 2 fact tables, it might be difficult to do that. And in most of the cases, it is 1:1 or 1:many relation. if i create sce 2, would it be very slow?
Sce 1
Dim_1 directly linked to Fact_1
Dim_2 directly linked to Fact_1
Dim_3 directly linked to Fact_1
Sce 2
Dim_1 linked to Dim_2
Dim_2 linked to Dim_3
Dim_3 linked to Fact_1
Sce 3
Dim_1 linked to Dim_2
Dim_2 linked to Fact_1
Dim_3 linked to Fact_1
And i have one dim table which does not have any common column with any other tables. How do i handle that? Indexing?
Thanks a lot,
