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

[AliShahab88]

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]

That is not an error. 

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

[AliShahab88]

@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]

Please post the error message from the Refresh History.

[AliShahab88]

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]

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

[AliShahab88]

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]

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]

thank you @lbendlin  for the stunning support