Forum Discussion

Camelguy79's avatar
Camelguy79
Frequent Visitor
3 years ago

Scheduled Refresh with Essbase Connector

I have created a Power BI dashboard that uses a connection to Essbase.  I can manually refresh the data via Power BI Desktop, but I cannot schedule a refresh after publishing. The error message (below) says that my creditionals are invalid, but I used the same creditionals to import the data from Essbase.  Everything that I have built is useless if I cannot schedule a refresh.  Any help is appreciated.  

 

Error message:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the Essbase source are invalid. (Source at https://companyurl/.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Essbase"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://companyurl?method=POST"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Essbase\",\"path\":\"https://companyurl?method=POST\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: Financial Data.

4 Replies

  • Hi Camelguy79 

     

    If you are using a Power BI Gateway Server, can you make sure that if you log into the Gateway server, then from there you can successfully connect to the Essbase source?

    • Camelguy79's avatar
      Camelguy79
      Frequent Visitor

      I have to admit I am a little new to publishing, gateways, etc.  As far as I can tell, I am connected via a gateway.

      I am using on-Premises data gateway (personal mode).  

      • KyleHenderson's avatar
        KyleHenderson
        Regular Visitor

        Did you ever get this resolved? I am having the same problem.