Forum Discussion
Certificate Chain Not Trusted Error Effecting PowerBI Only
This ended up being a fairly easy solution, in order to work around this issue I ended up just having to switch the connection type from MSFT account to Windows for any who encounter this issue in the future.
heoliv,
You would need to contact SQL Server database administrator about that where he stores the SSL certificate. Then import the certificate to the client computer that installs Power BI Desktop following the guide in the KB below.
https://support.microsoft.com/en-sg/help/316898/how-to-enable-ssl-encryption-for-an-instance-of-sql-server-by-using-mi
Regards,
Lydia
This ended up being a fairly easy solution, in order to work around this issue I ended up just having to switch the connection type from MSFT account to Windows for any who encounter this issue in the future.
Holy hell!! I have a PBI-report that has been refreshing fine for 2+ years. It gets the occasional update in PowerBI Desktop and is republished. It just decided to not refresh this sql.datasource last week. Today I spent 3 hours on Google to finally find this solution.
Thank you for posting this! By now, this should be a suggestion in the connection error message.
My takeaway - If Microsoft can find a way to f**k up my day, they will! Otherwise they invent a new way!This was so helpful, thanks! I had to look up how to make this change so i wanted to share with others:
In Power BI Desktop:- Open: Power BI Desktop.
- Go to File > Options and Settings > Data Source Settings.
- Select: the specific data source (e.g., a SQL Server instance) from the list.
- Click Edit Permissions.
- Change: the Connection Type to Windows Authentication.
This worked for me too, thanks!
Hi Syndicate_Admin,
I am having the same problem, before testing this workaround what are the implications of doing this on users trying to access the report across the network?.
Also do you have any idea what the switching to Oauth2 would do?
- Bless you for this.
