Forum Discussion

lnerii94's avatar
lnerii94
Frequent Visitor
1 year ago
Solved

Power BI/Essbase Connector Error

I had been working normally with the connector last week adding measures and dimensions without any problems. I created a table with the data from essbase, This week I refreshed the report and I'm ge...
Need Help
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi lnerii94 ,

    Open your Essbase tool and run the same query that Power BI is using. If the query returns results normally, then the issue might be within Power BI. If it fails, the issue may be with the Essbase server or query logic.
    Ensure your Essbase connector is up to date. Sometimes, older versions have compatibility issues.
    Once try accessing the Essbase endpoint directly:
    in browser
    curl -v https://<essbase-server-endpoint>

    if it's an HTML page with an error message, that confirms the issue is on the server side.

    Thanks and regards.
    Chaithra

  • lnerii94's avatar
    lnerii94
    1 year ago

    Hello v-echaithra just give you a little update. 

    The issue was solved, the network team restarted the XMLA service in the Essbase server. Now the connection between Power BI and Essbase is working.

    Thank you so much Again for your help.

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi lnerii94 ,

Open your Essbase tool and run the same query that Power BI is using. If the query returns results normally, then the issue might be within Power BI. If it fails, the issue may be with the Essbase server or query logic.
Ensure your Essbase connector is up to date. Sometimes, older versions have compatibility issues.
Once try accessing the Essbase endpoint directly:
in browser
curl -v https://<essbase-server-endpoint>

if it's an HTML page with an error message, that confirms the issue is on the server side.

Thanks and regards.
Chaithra

lnerii94's avatar
lnerii94
Frequent Visitor
1 year ago

I'm getting the error when I tried to create the connect before the query. I'm not able to run the query en essbase tool. A coworker tried to create in excel and he was able to do the connection and de query.


I tryed to do curl and this the message that I'm getting.


So the issue is on the server side?.

 

  • v-echaithra's avatar
    v-echaithra
    Community Support
    1 year ago

    Hi  lnerii94 ,

    Please ask your server or network team to check the Essbase web server logs, look for any malformed XML or HTML responses, restart the Essbase services, and also verify whether Smart View traffic and Power BI traffic are hitting the same URL and port.

    If still faces the same issue then please consider raising a support ticket for further assistance.
    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.



    Thanks and Regards
    Chaithra E.