Power Bi Dataset Loads slowly

[Anonymous]

Hello

I am connecting to a Power Bi Dataset using a live connection. I'm just using one table from this. I have created relationships with other imported DIM tables. When I create measures off the Dataset and load them into a Matrix or Table, it loads extremly slow. Does anyone know why this could be?

Thanks

[VijayP]

@Anonymous 

First try to remove the Cache as shown in the Snapshot !

Secondly Check PErformance analyser recording the steps and whether the data is creating latency

[Anonymous]

Hi Vijay

I have followed the steps and it's the same result. I have created a copy of the table and the performance is much quicker

[Anonymous]

Hi @Anonymous,

Can you please share more about the relationship mapping and DAX expression to help us clarify your scenario?

How to Get Your Question Answered Quickly  

In addition, you can also take a look at the following optimization guide of power bi if helps:

Optimization guide for Power BI - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng