Forum Discussion
Helper IError power bi " admin has granted access credentials are not required"
Helper I@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.
Super UserPlease 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?