Need help

[Anonymous]

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,

[v-yuta-msft · Accepted solution]

@Anonymous ,

I would suggest you refer to blogs below:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.