Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Dean Rochester]

Hi all

I have searched this one and all the solutions say to set the sql user/pwd in the database settings once the report is published.

I did that.  I tested the connection and it was successful too.

But when I go to run the report from the power bi server, I get 

We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly.

 I edit it on the Power Bi Server using Power Bi desktop without any issues.

This is a report where I used sql connection string and I am using a sql command for the query

Any assistance would be great

Thanks in advance
Dean-O

——————————
Dean Rochester
——————————