Forum Discussion
Helper IError Communicating with Analysis Services - Failed to create the MSOLAP command.
Helper IThank you for your follow up- it's good to know that I am seeing the same thing as you are.
Could you assist in checking your connection string for me? I believe at this point the error has to do with the connection but cannot pinpoint where the permissions need to change.
This is the connection string that is created when I publish the report from report builder to the service. As you can see, the connection is offline. There isn't an option to change the authentification method to windows auth either.
I believe that this is the root cause of these issues but i have no ability to modify the connection to accept windows auth as the cause. Would you know how to modify this so that I am able to bring this connection string online?
Hi,ucmaoTWG .Thank you for your reply.
It has come to my attention that you may have some misconceptions. I hope my suggestions below will help you.
1. Whether a gateway is required to create a paged report using semantic model on Power BI Service as a data source.
As you can see from my previous test in Report Builder, I did not set up any gateway connection.
The need for a gateway connection depends on where the report and the data source are located. If both are in the cloud (both stored in Power BI Service), there is no need to configure a gateway connection.
I don't think you need to create a gateway connection for the paged reports you produce.
2. About the connection string issue
If you are using other report's semantic model as data source in Power BI Service and want to see the connection string of that semantic model.
Semantic model> settings> Server settings
And you are using a cloud data source and creating the same cloud gateway connection. Windows authentication is not supported when the data source is in the cloud. You have to authenticate via OAuth 2.0.
The root cause of this is that the semantic model you are using is stored in Power BI Service and you can only access this semantic model by logging in through your Power BI Service account and not through your windows account (this is by design).
Connecting using a connection string is essentially the same as connecting graphically.
I recommend that you connect semantic models graphically rather than comfortable strings yourself to avoid data errors. (In Power BI Report Builder)
3. About Power BI semantic model (AS model) as a data source , service support for data source authentication.
Currently, the only authentication methods for semantic model are OAuth 2.0 and Basic.
I have reproduced your operation (making RDL report in service)
create rdl report
I think where you are really having problems is with the connected semantic model.
As you can see I didn't set up any gateways during the whole test.
If you are having problems with your data source credentials. Then it is likely that you are having problems connecting to the data source gateway of the semantic model itself when you are connecting to the semantic model.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.