Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
motiwala71
New Member

Error Message

‎06-29-2022 02:13 AM

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?

 

Labels:
Message 1 of 2
346 Views
0
1 REPLY 1
SpartaBI
Community Champion
Community Champion

‎06-29-2022 02:27 AM

@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.


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

Message 2 of 2
315 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All