Forum Discussion

AliShahab88's avatar
AliShahab88
Icon for Helper I rankHelper I
4 years ago

Error power bi " admin has granted access credentials are not required"

Dear All,   I am getting below Error while using SQL Database and username and password or ok.   " admin has granted access credentials are not required"   anyone help regarding the above issue...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

That is not an error. 

You should be more worried about the skipped connection test. What's your reasoning for that?

AliShahab88's avatar
AliShahab88
Icon for Helper I rankHelper I
4 years ago

@Ibendlin, I am using a Test connection check to test my connectivity its working fine but when refreshing the report the above error is occurring. plz help regarding this.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Please post the error message from the Refresh History.

    • AliShahab88's avatar
      AliShahab88
      Icon for Helper I rankHelper I
      4 years ago

      Something went wrong

      There was an error when processing the data in the dataset.

      Please try again later or contact support. If you contact support, please provide these details.

       

       

      Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}} Table: company_finance.
      Cluster URI: WABI-WEST-EUROPE-E-PRIMARY-redirect.analysis.windows.net
      Activity ID: dc38067f-733f-420c-8dbc-5c1accfb8d98
      Request ID: acf9f526-7701-3429-4b5d-abf35a448490
      Time: 2021-10-14 06:40:24Z

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        Your query against Company_Finance took too long and ran into a timeout, likely on the SQL side.