Finance | Project Operations, Human Resources, ...

Error while logging to Power BI Desktop wit Entity Store Database(AxDW)

(0) Share

Report

Posted on by Sanjay kumar singh

240

Some days back I was able to connect Powerbi Desktop.with what Microsoft guideline

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/author-distribute-power-bi-reports

6735.CONNECT.png

but now I am getting some ssl error.How can I resolve this.

0550.sslError.png

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Ajit 8,755 on at

Like (0)

Report

Looks like firewall issue. Are you trying from your Dev VM? try putting server instead of dot and see if that works.

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Kumar,

Did you connect to the local Entity Store database?

In this case, either the certificates haven't been installed, or they haven't given access to the correct users. To resolve this error, add the public key SQL Server certificate to all the Service Fabric nodes.

docs.microsoft.com/.../troubleshoot-on-prem

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi Sanjay,

looks like you are accessing through your local, this will only connect within server only. Please login to server/VM and try .

Was this reply helpful? Yes No
Sanjay kumar singh 240 on at

Like (0)

Report

Hi ,

I am using One BOX(VHD) installation.Althought I tried with server name as well, same error

Was this reply helpful? Yes No
Sanjay kumar singh 240 on at

Like (0)

Report

Yes,

I am connected with AxDW Database, where can I find the SQL Server certificate, can you give me some more detail.

My installation is One Box(vhd) installation.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

see if this helps

cloudblogs.microsoft.com/.../

http://axhelper.com/?p=25542

community.dynamics.com/.../d365-cloud-hosted-dev-environment-certificate-expired

community.dynamics.com/.../how-to-fix-certificate-expiry-in-d365

Was this reply helpful? Yes No
Sanjay kumar singh 240 on at

Like (0)

Report

Hi,

Below are my One Box Machine Certificates,

I think no one expired , How can we know which is for PowerBI?

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

here are the ones

DeploymentsOnebox.DaxRunnerTokenUserCertificate.pfx

DeploymentsOnebox.LcsClientCertificate.pfx

DeploymentsOnebox.MRClientCertificate.pfx

DeploymentsOnebox.SessionAuthenticationCertificate.pfx

this has more details

community.dynamics.com/.../fix-certificate-issues-on-development-machines

Was this reply helpful? Yes No
Sanjay kumar singh 240 on at

Like (0)

Report

All DeploymentsOnebox certificates are Future(2/24/2021,not expired) date in my One Box machine.so I think,Certificate cloning will not resolve my issue.

Was this reply helpful? Yes No