Error Message

[motiwala71]

I worked on some report and publisehed it like a month ago.
It was working perfectly, refreshing and updating daily data an so on.
Just recently some 4-5 days back when i refresh data the report showed error on desktop as well as on services with the below details:
"An argument of function 'MID' has the wrong data type or has an invalid value"

I tried to enter the formula again but till date no solution.
Can any1 advise what and where is something wrong happened?

[SpartaBI]

@motiwala71 check to see what column you use in the MID function, maybe it's type changed in the datasource so maybe change the type back in Power Query or add that change type logic in the measure.

      

Showcase Report – Contoso By SpartaBI