object reference not set to an instance Dataflow

[BIIS]

Hi,

Please can someone help me out with this error?

I have a data flow that was created some months ago from the service. Everything looks normal and I could preview my data import from the MySql database.

Recently, (last week) I tried making changes to the dataflow, but once I clicked on the edit query side, I popped out with this error

"object reference not set to an instance "
I tried creating a new data flow and still faced the same error. Can someone help me out?

[v-cgao-msft]

Hi @BIIS 

1. Does this error only appear on the service? If the refresh operation is performed in Power BI Desktop, will this error occur?

2. Have you updated the mysql driver recently? Try installing the previous version of the driver.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[BIIS]

Yes, @v-cgao-msft,

 It only appears on the service.

Everything works perfectly on the desktop.

My gateway is updated as well.

Regards

[BIIS]

@Greg_Deckler please can you help me out here?

[Greg_Deckler]

@BIIS That's a tough one to troubleshoot. Perhaps this will help: Data Flow run failed(error: Object reference not set to an instance of an object), could you help to...

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".