i have done with gateway and also scheduled the auto refresh time, but getting failed

[Gnaneshwar_3012]

please fine below error

There was an error when processing the data in the dataset.Hide 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":"Access to the path 'C:\\Users\\LENOVO\\Desktop\\power bi KSR ALL\\POWER BI KSR\\DATA SETS\\superstore\\SUPER STORE DATA.xlsx' is denied."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"C:\\Users\\LENOVO\\Desktop\\power bi KSR ALL\\POWER BI KSR\\DATA SETS\\superstore\\SUPER STORE DATA.xlsx"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Orders.
Cluster URI:	WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID:	453d84a1-09e5-4627-b3d3-4663dd394b91
Request ID:	59c483a1-3282-ad29-5179-c34a8173382b
Time:	2024-06-27 18:50:39Z

could you please suggest on this any resolution , expecting soon respone.

[Wikkleyn_81]

Hi @Gnaneshwar_3012 When creating the connection, ensure you have the servername or then full location name of the file you are connecting to e.g. \\servername\folderpath\file.xlsx and ensure the user has permission to the folder

[v-yilong-msft]

Hi @Gnaneshwar_3012 ,

I  firstly think you need to ensure that the user account running the Power BI service has the necessary permissions to access the file at C:\Users\LENOVO\Desktop\power bi KSR ALL\POWER BI KSR\DATA SETS\superstore\SUPER STORE DATA.xlsx.

If you’re using an on-premises data gateway, make sure it is properly configured and running. Also you need to ensure that both Power BI Desktop and the on-premises data gateway are up-to-date.

Based on the same problem encountered by previous users on the forum, I think you can also retool the query, you can refer to the following topic: Solved: DM_GWPipeline_Gateway_MashupDataAccessError (Not l... - Microsoft Fabric Community

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.