This has been happening to me on and off for the last couple months:
When I try to refresh a report in the desktop, I sometimes receive this error, and once I receive it on a particular file it continues to happen over and over again. In this particular case, I am connecting to an Azure instance and attempting to refresh tables and views.
"Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"
I've resolved this in two different ways:
1. Options and Settings -> Data Source Settings -> clear permissions or clear global permissions and provide credentials again.
2. After trying every clear permissions route I could think of, I published to a workspace, and then I tried refreshing on the desktop and it worked!
However, I'm encountering this problem again and neither of these past solutions works. I can go into another pbix file and do the same refresh and it works. It seems something becomes corrupted in the file??? Microsoft, is this a bug? Lots of postings about it on the Internet with lots of different solutions. I'm unable to find the solution that works for me.
Is anyone else running into this? Has anyone else found a solution?
v-xiaoyan-msft
on:
"Sort by column" should work regardless of key col...