Unable to connect to database with same access as two others I can connect to - severe error

[Anonymous]

Hi there,

I am starting to use Power BI for the first time and am having a little trouble with a particular database.

I have created a user with access to a number of databases under user mapping on the SQL server with the access db_datareader so they can have view access to the DB. This has been provided to 3 different databases.

Inside power BI I am able to connect to the SQL server with this account and query 2 out of 3 databases (The one I am unable to connect to being the most important, as it has the tables I wish to query)

As shown below:

What am I missing?

[v-lili6-msft]

hi, @Anonymous

I cannot reproduce your scenario. and it seems that it is a problem for SQL Server.

here are some articles for you refer to:

https://support.microsoft.com/en-us/help/2421014/fix-a-severe-error-occurred-on-the-current-command-error-message-when

https://vickyharp.com/2012/03/troubleshooting-a-severe-error-occurred-on-the-current-command/

hope it could help you.

Best Regards,

Lin

[Anonymous]

I managed to find the SQL dump file for this error message - would that help?

I'm not entirely sure what I am looking for.