Forum Discussion
Helper IError Communicating with Analysis Services - Failed to create the MSOLAP command.
Hi,ucmaoTWG .I am glad to help you.
It looks like you had an error configuring your cloud gateway connection and the system says it can't access your AS data source
Connection string issue:
The connection string for the data source may be incomplete or misconfigured, such as incorrect server address, database name or port number.
You mentioned that your team has restricted windows authentication methods. I think this could potentially cause the issue.
If the ENTRA configuration does not allow Windows authentication and the data source (e.g. Analysis Services) requires Windows authentication, this can cause the connection to fail.
Can you please check that you have correctly configured the service body or user permissions when using Azure AD OAuth authentication.
I hope the following links are helpful.
URL:
Connection string properties (Analysis Services) | Microsoft Learn
Authentication methodologies supported by Analysis Services | Microsoft Learn
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.
ucmaoTWGThank you for your response- I do have a few follow up questions I hope you can clarity as we research this on our side as well.
1) The connection string is automatically generated when publishing the paginated report from the powerbi report builder utilizing the 'Add Power BI semantic model connection..." as the datasource. Furthermore, it also fails when utilizing the web-based create a paginated report (preview) option as well. Is it possible that both of these are failing to auto generate the correct connection string?
2) We do not have a dedicated analysis server in our azure tenant. We are currently utilizing the 'built in' shared analysis server that powerbi utilizes. We would still need to have the correct authentification methodology set up for this correct?
Thank you for your assistance- this has been the most support i've received on this issue so far.
Hi,ucmaoTWG .Thank you for your reply.
In fact, I don't think you need to set up a gateway connection for your paged reports anymore (at this point, both the data source and the paged reports are in the Power BI Service in the cloud, and there is no need for a gateway to act as a bridge, the system will automatically retrieve and update the paged reports)
The gateway is only needed if the data source and the report are not in the same location (whether it's a local enterprise gateway or a cloud gateway)
After my testing, I used pbix reports in Power BI Service (AS model in the cloud) as the data source after creating paged reports. The final paging report published to Power BI Service does not require a gateway connection (the system doesn't even give a button to set it up)
As you can see I can't change the data source credentials for this paging report and configure the gateway link. (The data source is semantic model i.e. AS model in the cloud)For other paging reports made with local data sources you need to configure a gateway to complete the refresh. (The data source is a local SQL Server database.)
Below is my test:
Publish pbix to Power BI Service and use the semantic model (In Power BI Service)
create the rdl file in Power BI Report Builder.
Can not edit the RDL report.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.- ucmaoTWG
Thank 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?