Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
8 months ago
Solved

There 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....
Need Help
Show and Tell
Tips and Tricks
  • julsr's avatar
    julsr
    8 months ago

    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! 

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
8 months ago

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!