Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Cado_one
Resolver III
Resolver III

Program execution reached an invalid state

Hello,

 

a similar topic already exists Program execution reached an invalid state - Microsoft Power BI Community but no answer was given.

I think an important bug came with the last Power BI Desktop update : when trying in the Desktop to refresh a MySQL datasource which has a "Changed Type" step in the query editor to convert a column to date/time type the following error appears :

Cado_one_0-1652082379255.png

This error only occurs in the desktop app, the refresh in service is okay.

I know other people face the same issue but does anyone knows how to get rid of it or if a bug fix is coming ?

 

Thanks in advance,

Best regards,

Cado

1 ACCEPTED SOLUTION

I solved the issue.

After looking more in details it appeared that the problematic columns changed for type date/time were already in date/time format before the "Changed type" step.

And it looks like Power Query doesn't like when we change a column for a type it already has !

It makes no sense but that's the way it is 

 

Have a good day

Cado

View solution in original post

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Cado_one 

Thanks for reaching out to us.

May I ask what type of field are you trying to convert to date/time format? And in order to better troubleshoot, I need to confirm the following problems first
(1) I read the link you posted, and some users said that there is also a problem with the report on the service. Could you please reconfirm whether the SQL data can be updated to the report on the service?
(2) Was the report created before and worked fine on both desktop and service before? Then are there any changes to the report, such as privacy level settings.
(3) Regarding this error, it is usually due to "Your database connection has timed out, or your database has been closed. You may need to retry the query, or reconnect the session." If you create a new pbix file, and establish a connection, then change the type in power query, will you still get the same error?
(4) If none of the above helps, please let me know, I will investigate further.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xiaotang 

 

(1) In my case it's just on the Desktop (I didn't republished the report to service ever since because I'm afraid it won't work anymore if I do)

(2) The report is not new, it was working perfectly and this error suddenly appeared without any change from my hand.

(3) I just tried to create a new connexion in a new report, it's okay at first but as soon as I change a column type to Date/time in the query editor the same error appears.

(4) Thanks for helping me, I'm looking forward to read from you !

 

Thanks again,

Cado

I solved the issue.

After looking more in details it appeared that the problematic columns changed for type date/time were already in date/time format before the "Changed type" step.

And it looks like Power Query doesn't like when we change a column for a type it already has !

It makes no sense but that's the way it is 

 

Have a good day

Cado

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.