Power Bi Dataset Loads slowly

Question

Hello&nbsp;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?&nbsp;Thanks

vijayp · Answer

Anonymous&nbsp;
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

&nbsp;

anonymous · Answer

Hi Vijay&nbsp;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 · Answer

Hi&nbsp;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&nbsp;&nbsp;
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

Forum Discussion

Power Bi Dataset Loads slowly

3 Replies

Related content

POWER BI DATASETS

Refresh Power BI Dataset using Power Automate

AI functionality using Power BI Dataset

Refresh dataset api

Power BI Dataset RLS - Power BI Report Builder