Adding a certain column to a table visualisation causing load time/performance issues

[Anonymous]

Hi all, hoping someone can help as I'm stumped and even a PowerBI trainer I worked with hasn't been able to get to the bottom of this.

There is a specific attribute/column that is causing me problems whenever I add it to visuals or measures, it is making everything run slower. It is a column that I have added to the table using Power Query (Transform) and it is has been created in exactly the same way as all other columns I have added. I have deleted and readded it to make sure it is set up the same as the others and I still have problems. 

The column is [Stage Resolve Date] which is a combination of [Stage1ResolveActualDate] and [Stage2ResolveActualDate]
This is set up exactly the same way as [Stage Resolve Target Date] which is a combination of [Stage1ResolveTargetDate] and [Stage2ResolveTargetDate]

Normally I would just want to display the combined columns [Stage Resolve Target Date] and [Stage Resolve Date] however I am displaying all of them above just to show that it is indeed the same column

If I add [Stage Resolve Date] to the table, it makes everything slow, refreshes take about 10-15 seconds longer. If I remove the column and add the separate parts, everything runs fine. I want to use the combined column so it is a better user experience. 
If I add/remove [Stage Target Resolve Date] it has very little effect on load time. 

Has anyone come across this issue before?

UPDATE:

For no obvious reason, there is a workaround that seems to be helping:

I created a duplicate of the column [Stage Resolve Date] and by using this duplicated column in my table visual, it now loads several seconds quicker. 

I thought it might be because [Stage Resolve Date] is being using in nearly every measure in my report, whereas the duplicated version is not used anywhere? But that sounds very unlikely. 

[Anonymous · Accepted solution]

UPDATE:

For no obvious reason, there is a workaround that seems to be helping:

I created a duplicate of the column [Stage Resolve Date] and by using this duplicated column in my table visual, it now loads several seconds quicker. 

I thought it might be because [Stage Resolve Date] is being using in nearly every measure in my report, whereas the duplicated version is not used anywhere? But that sounds very unlikely. 

[Bibiano_Geraldo]

Hi @Anonymous ,

Use the Performance Analyzer tool in Power BI to identify which steps or visuals are causing the slowdown. This can provide insights into where the bottleneck is occurring.

You can learn more about Performance Analyzer here

[Anonymous]

Hi, I have done this, unfortunately without DAX Studio I won't be able to get to the detail of what I need

[johnt75]

My first thought would be to check whether there is a relationship from [Stage Resolve Date] to any other tables - Power BI can automatically create relationships unless you disable that setting.

My second thought would be to use Performance Analyzer to get a copy of the query which you can then examine in either DAX Query View or DAX Studio. If reading through the query doesn't raise any flags, such as unexpected tables or filters, you can run it in DAX Studio with Server Timings enabled, and see what it is doing under the hood.

[Anonymous]

There was a relationship (that I created) but I deleted that and the issue remains. I even deleted and rebuilt the column after that to make sure.

Reviewed the query in DAX Query View with the trainer and it didnt show anything, he also suggested getting DAX Studio to look into this further. I'll have to put in a request to unblock the download so I'll get on that.