Data refresh filter too slow

[suxi]

It takes more than 10 hours to download a report no more than 400Mb.

Also, when I was tring to change a DAX scripts in this report, it takes me more than 10 hours to apply the changes.

original scripts:

= Table.AddColumn(#"Renamed Columns", "Overview Tile", each if Text.StartsWith([Action], "overview") and Text.Contains([Action], "featureadoption") then "Feature Adoption Tile"
else if Text.StartsWith([Action], "overview") and Text.Contains([Action], "opportunities") then "Opportunities Tile"
else if Text.StartsWith([Action], "overview") and Text.Contains([Action], "pilot") then "Pilots Tile"

else
"Any")

new scripts:

= Table.AddColumn(#"Renamed Columns", "Overview Tile", each if Text.StartsWith([Action], "overview") and Text.Contains([Action], "featureadoption") then "Feature Adoption Tile"
else if Text.StartsWith([Action], "overview") and Text.Contains([Action], "opportunities") then "Opportunities Tile"
else if Text.StartsWith([Action], "overview") and Text.Contains([Action], "pilot") then "Pilots Tile"
else if Text.Contains([Action], "gainers") then "Top Gainers and Decliners Tile"
else if Text.Contains([Action], "decliners") then "Top Gainers and Decliners Tile"

else
"Any")

Do you know why it is too slow?

[v-jiascu-msft]

Hi @suxi,

How about a DAX formula? Maybe it will be faster. Can you share a sample?

The possible causes:

1. Large amount of data.

2. The functions apply comparing substring with a string. This could be slow. 

Best Regards,

Dale