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.
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!