Unable to Refresh Power BI Report after update

[Sheikhu]

Hi All, I recently installed new version of Power BI. Since then, I am unable to manually refresh my Power BI report and encountring encryption errro in power bi , if i click on ok , its just circle back to same scree.

But I can still connect to the same SQL server using SSMS and excel power query without any issues. Does anyone know how to resolve this problem?

Thank you .

[Ritaf1983]

Hi @Sheikhu 
Please relate to the linked discussion about the same issue:
https://community.fabric.microsoft.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-...

You need some modifications in ssms.

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

[Sheikhu]

Hi , I have tried to acces the sql server using windows authentication that hasnt resolved the issue and I only have read only access to sql server i cant make modifications. Other colleauges can connect to SQL server but as i am newer version of power bi ,its not letting me make connection . I can connect to power query in excel and other SSMS using same name and credential . Is there anyway i can connect to power bi as i was able to on older verison of Power bi in windows 10.