Power-BI Connectivity Issue 

Problem: end-user received an error in the Power BI Desktop while connecting to the SQL  server. 

Troubleshooting: 

1. Open your Power BI Desktop app.
2. Click 'File'
3. Click 'Options and Settings'
4. Click 'Data Source settings'
5. Select the offending SQL server instance, from the list of data sources.
6. Click 'Edit permissions' button at base of prompt screen.
7. In this new prompt screen, under the 'Credentials' section, click the 'Edit' button to open a new prompt and select 'Windows.'
8. Select either 'Use my current credentials' or 'Use alternate credentials' (up to you, I just used mine)
9. Click' Save' button to close this prompt and return to the 'Edit Permissions' prompt screen.
   1. In here there is an 'Encrypt connections' option. If your server accepts encrypted connections this will need to be ticked, mine doesn't and so I left it blank.
   2. If you're not sure, don't worry. When you click 'Refresh All' a prompt will tell you if you need to be unencrypted and you can come back and untick this box.