Erroro connecting to SQL server

Question

Hello.&nbsp;I have been working on a report in power bi for a while. Suddenly I cannot connect to my server anymore. I get the following error:&nbsp;Details: "An error happened while reading data from the provider: 'System.IO.FileLoadException'"&nbsp;Ayy suggestions about how to solve this?&nbsp;Thank you for your help

joernolav · Answer

Thanks, sorry for late anser but somehow it was solved by itself. &nbsp;I dont know why.

greg_deckler · Answer

You can take a look at this similar thread:

https://community.powerbi.com/t5/Integrations-with-Files-and/Unable-to-Connect-to-SQL-Server/td-p/124561

One more:

https://community.powerbi.com/t5/Integrations-with-Files-and/System-IO-FileLoadException-SQL-or-Named-Pipes-Provider-error-40/td-p/110952

Also, this troubleshooting guide here:

https://msdn.microsoft.com/en-us/library/dbe81ttk.aspx?f=255&MSPPError=-2147217396

greg_deckler · Answer

Hey, as long as it is solved! I would blame it on gremlins, or maybe underpants gnomes...

Forum Discussion

Erroro connecting to SQL server

3 Replies

Related content

Can't Connect Fabric Core MCP Server

Problem connecting to report server

Power BI MCP Server not connecting to Power service

Fabric Connect to SFTP Server

Notebook connecting to SQL Server