cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rodneyc8063
Helper V
Helper V

PBI Desktop - Formula bar not showing entire error message?

So I was trying to create a calculated column, and was entering some code in the PBI desktop formula bar

 

The code is quite simple and is just like this: 

 

Test = FORMAT(Date_Test[Date], "MMM YYYY")
 
I hit an error (I know why after investigating), but I noticed that when trying to expand the error message - I either cant see it or its not complete?
 
I see the following: The following system error occurred:
 
error.jpg
But thats it? I tried to expand the formula bar window, and dig around but for the life of me I am NOT able to see the full error message?
 
Not sure if I been at this too long and my brain has shut down and I missed something small, but has anyone else seen this? Any idea how to fix this and be able to see the FULL error message?
1 ACCEPTED SOLUTION

Hi, @rodneyc8063 ;

 

Accoridng to the official document;  The following system error occurred: Type Mismatch ;so  you are not the only one with this issue.

If your problem is solved, would you like to mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

6 REPLIES 6
v-yalanwu-msft
Community Support
Community Support

Hi, @rodneyc8063 ;

 

Please make sure that the type of DATE_TEST [DATE] is Date.

If it does not make sense, please share me with your pbix file after removing sensitive data.

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Hi @v-yalanwu-msft 

 

I actually had 2 problems here

 

1 - I had to fix DATE_TEST [DATE]  to make it a DATE data type - Then I no longer get an error (this is solved)

 

2 - When I did get the error, as you can see in the screen shot - There was no error message. It just said The following system error occurred: So it wasnt easy to trouble shoot at first, since there was no clear error message.

 

Error message.jpg

Just adding a Google drive link here: https://drive.google.com/file/d/1kuCefiiQTmgEwU6ho4wH0KmjSXAoCiC4/view?usp=sharing

 

Second issue is very minor but also curious am I the only one with this issue

Hi, @rodneyc8063 ;

 

Accoridng to the official document;  The following system error occurred: Type Mismatch ;so  you are not the only one with this issue.

If your problem is solved, would you like to mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

Thanks @v-yalanwu-msft for the detailed reply!

amitchandak
Super User
Super User

@rodneyc8063 , This is strange. Make sure you are on the latest version. Save and close all power bi files and start again

 

Also, make sure Date in this formula is having data type date

 

Test = FORMAT(Date_Test[Date], "MMM YYYY")

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Hi @amitchandak - I am on the most current PBI desktop version (May 2021).

 

I tried to close and restart "fresh" a few times but I still get this weird behaviour.

 

You are right about the column being used in the formula, its actually an integer so thats why there is an error. 

 

I just found it very strange that I cant actually SEE the error. 

 

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors