cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdenne1985
Frequent Visitor

Unable to publish Report since November 2020 Release overnight

Good morning,

 

Is anyone else having issues publishing their Power BI reports to the service since the November 2020 Desktop (2.87.684.0 64-bit) release overnight?

 

James

2 ACCEPTED SOLUTIONS
tuannie
Microsoft
Microsoft

There is an option in File > Options and settings > Options > Security > "Enable certificate revocation check". Can you try disable/uncheck that option and sign in again?

 

Please let us know if that fixes the issue.

View solution in original post

tuannie
Microsoft
Microsoft

Here is a bit more context on this issue. Starting in the November 2020 release, PBI Desktop will harden requirements for SSL certificates (see the "Certificate revocation check for web connections" section in https://powerbi.microsoft.com/en-us/blog/power-bi-november-2020-feature-summary/#_Toc55467058). This will require some organizations to upgrade their current SSL certificates. This is done to ensure more secured communications between PBI Desktop and PBI Service.

 

We will update with more documentations on how to upgrade SSL certificates. In the meantime, the workaround is to temporarily disable the option

File > Options and settings > Options > Security > "Enable certificate revocation check"

 

View solution in original post

22 REPLIES 22
tuannie
Microsoft
Microsoft

Hi @CTOUT, we have released a new version for November that rolled back the new SSL certificate enforcement. We are working on giving more UI options for users and admins to control this setting as well as writing up documentation. All these changes will probably come in the February release of PBI Desktop (but the timeline may change).

tuannie
Microsoft
Microsoft

We're releasing a new version of November release (it should be available either today or tomorrow). This new version will revert the new SSL certificate hardening so we have more time to provide guidance/documentation for upgrading SSL certificates and your system/network admins have more time to upgrade. Please note that the SSL certificate upgrade will most likely be done by your system/network admin.

 

A bit more technical information, the recent PBI Desktop change requires all SSL certificates to have a "certificate revocation list" (CRL). In short, the CRL allows PBI Desktop to verify that the certificate is still valid. All Microsoft issued certificates are compliant. The scenario where you most likely run into issue is corporate proxy. If your organization has a corporate proxy and the SSL certificates used by the proxy (these certificats are internal to the organization) don't have CRLs, then PBI Desktop will reject them.

Thanks for the response, @tuannie - although it would be preferable to get some warning before implementing such a breaking change in future. 

 

I'm happy to work with you on testing this out if that is of any benefit.  

@CTOUT  really appreciate the offer. We're working on some documentations, so I'll update this thread when we have them. And it'll be great to get some feedback on whether the documentations help.

Hi @tuannie,

 

Has there been any development on this?

CTOUT
Helper II
Helper II

The certs I've been pointed at were https://docs.microsoft.com/en-us/azure/security/fundamentals/tls-certificate-changes
However, adding these root CAs to the server running the On-Premise Data Gateway did not resolve the issues encountered in the November 2020 release.

cvillegas
Advocate III
Advocate III

@tuannie Do you have the certs whereby you can at least attach them? I keep seeing that the upgrade of the certs need to be done. This also impacts the Power BI Gateway as well.

vmucchielli
New Member

Thanks, we had the same issue within our organization. Please keep us posted when the doc is ready. Upgrade of SSL certificate might take a long time in a large company

tuannie
Microsoft
Microsoft

We're working on providing guidelines for upgrading SSL certificates (this is something that need to be done by system/network admins). I'll update this thread when we have documentations.

srikanthnama
Helper II
Helper II

How can this be released without having the steps or required documentation on how to handle the SSL certification in place ? This is causing lot of confusion and unnecessary workarounds.

tuannie
Microsoft
Microsoft

Here is a bit more context on this issue. Starting in the November 2020 release, PBI Desktop will harden requirements for SSL certificates (see the "Certificate revocation check for web connections" section in https://powerbi.microsoft.com/en-us/blog/power-bi-november-2020-feature-summary/#_Toc55467058). This will require some organizations to upgrade their current SSL certificates. This is done to ensure more secured communications between PBI Desktop and PBI Service.

 

We will update with more documentations on how to upgrade SSL certificates. In the meantime, the workaround is to temporarily disable the option

File > Options and settings > Options > Security > "Enable certificate revocation check"

 

View solution in original post

We were also having problems connecting to our azure analysis services tabular models due to the update, however, the workaround solved this too. 

Thanks @tuannie for the update. I can confirm the workaround has worked for me. Do you have an approximate timescale for the release of the SSL certificates documentation?

tuannie
Microsoft
Microsoft

There is an option in File > Options and settings > Options > Security > "Enable certificate revocation check". Can you try disable/uncheck that option and sign in again?

 

Please let us know if that fixes the issue.

View solution in original post

pacofq
Frequent Visitor

This did fix my problem to! Thanks so much!

That fixed it for me -- THANKS!

dsdesrosiers
Frequent Visitor

Ditto here - ...frustrating to say the least. 

Echbeir11
Regular Visitor

Has anyone gotten any information regarding this? We have a few users who cannot sign in via the November 2020 PBI Desktop too. 

ibarrau
Super User
Super User

That's really strange because I can't find any reference to november. Even documentation when clicking on "last update" sends me to october documentation. You can try even older:

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

Regards,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

I am having a similar issue -- cannot sign into DESKTOP so I cannot publish.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!