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...
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.

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

    Query is ok but connection issue, lbendlin  plz also guide me if we connect through VPN which IP and will be used in Power BI gateway I mean original IP or VPN IP crdential?

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

      The gateway cluster members act as headless PCs. They use exactly the same connection as what you use on Power BI Desktop. You need to guarantee that they have line of sight to the original address of the data sources you use.

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

        thank you lbendlin  for the stunning support