Power Bi Dataset Loads slowly

Anonymous · ‎03-02-2022

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 · ‎03-02-2022

@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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Anonymous · ‎03-02-2022

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 · ‎03-07-2022

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