Reading from the stream has failed

[obulibalaji]

Hello,

I am trying to connect a corporate server's MySQL database with Power BI.

But I got an error stating "MYSQL: Reading from the stream has failed"

Could anyone please help me with this.

Thanks in advance,

Obuli

[prateekraina]

Hi @supriya_13 , Sorry this was back in 2018. I don't remember finding any solution for this.

[neutronest]

Same problem... Any workaround ?....

[AnthonyTilley]

take a look at section 4 solutions in this article 

http://www.voidcn.com/article/p-phfoefri-bpr.html

[supriya_13]

@AnthonyTilley  Yes, I tried with removing ssl certificates from server . but that didn't work. 
Also for the second solution, I have alot of reports hence can't put anything that need updaing serval times a month. 
Also, I can connect it with localhost database, this issue is with server DB.

[Eric_Zhang]

@obulibalaji

That seems a known MySQL bug, could you try the workaround as suggested in that link?

[prateekraina]

Hi @Eric_Zhang @obulibalaji,

I have also encountered this issue and i am not able to resolve. Any help would be appreciated.

Regards,

Prateek Raina

[supriya_13]

@prateekraina Did you get some update on this

[jimmy7377]

Really could use some help to find a solution to this, if anyone can help?