Forum Discussion
Continued ContributorThere was an error communicating with analysis services. error in the high-level relational engine.
Hello everyone,
I'm working with Excel connected to a Power BI semantic model. I'm using it to insert a table in Excel by "CreatedDate" (as rows), with "Sales" and "Count of Customers" in values.
I use "Count of Customers" to only count the accounts where the "Sum of Sales > 0 for each date in the filters section and it works. The problem is when I join 3 semantic models (all semantic models are with Incremental Refresh functionality published online) using a Direct Query connection, I publish it and then I try to connect Excel to this semantic model. However I'm getting the following error:
"There was an error communicating with analysis services. error in the high-level relational engine. A connection could not be made to the data source with the name of ""
What's wrong?
Hi everyone,
Thanks for all the answers! I solved the problem.
The issue was coming from using the "Analyze in Excel Online" feature, and I was also seeing the same problems when using Excel on my laptop. What I did was open the semantic model that contains the 3 joined semantic models and tried to replicate the same setup inside it. This way the error appeared explicitly, so I could identify and fix it properly. Then I tried connecting again.
For some reason, when connecting directly to the semantic model, the error message wasn't displaying the full details.
Thanks again for the help!
3 Replies
- julsr
Hi everyone,
Thanks for all the answers! I solved the problem.
The issue was coming from using the "Analyze in Excel Online" feature, and I was also seeing the same problems when using Excel on my laptop. What I did was open the semantic model that contains the 3 joined semantic models and tried to replicate the same setup inside it. This way the error appeared explicitly, so I could identify and fix it properly. Then I tried connecting again.
For some reason, when connecting directly to the semantic model, the error message wasn't displaying the full details.
Thanks again for the help!
- GilbertQ
Super User
Hi julsr
From my understanding, the reason is you're joining three semantic models and then using a direct query connection and this has to grow across the multiple semantic models which is potentially causing the issue. I would recommend instead of trying to go across the three semantic models, you put all the data in a single semantic model. Just as a side note, when you are trying to do accounts of distinct customers where the sales is greater than zero, this is a very compute intensive operation also.
- cengizhanarslan
Do you have build permission on those models? To be able to connect via Excel you specifically need a build permissoon model.
