Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Aodren_Collet
New Member

Error : "Unable to find a part of the path"

Hi, 

 

I want to schedule an update on power bi service. For that, I have created a gateway with the different access paths to my Excel files but when I try to update afterwards, I get this error:

 

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": "Unable to find part of path 'N:\7- PRODUCTION\2-Prep\5-Follow-up Performance CUP 2023. xlsx'."}},{"code": "DM_ErrorDetailNameCode_UnderlyingHResult", "detail":{"type":1, "value":"-2147467259"}},{"code": "Microsoft.Data.Mashup.ValueError. Detail", "detail":{"type":1, "value": "N:\7- PRODUCTION\2-Prep\5-Performance Monitoring CUP 2023.xlsx"}}},{"code": "Microsoft.Data.Mashup.ValueError.Reason", "detail":{"type":1, "value": "DataSource.Error"}}], "exceptionCulprit":1}} Table: BDD Perf.
Cluster URI: WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: c09f7b79-ad2e-4c77-84d7-3f35b544a927
Request ID: b6c8c666-adb3-b23b-1d48-46d11f4ff624
Time: 2023-03-07 09:05:41Z

 

I have got this for my 6 Excel files. I think it is because my files are on the company network (disk N) but I don't know why It can't work. 

 

Can someone help me ? What could I do to fix that ? 

 

Thanks in advance for your help !

 

PS : it is th first time I try to use that sorry if it is a simply question 

PS 2 : I use the free test of Power BI pro for the moment

PS3 : Sorry for my english 

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi , @Aodren_Collet 

According to your description, the error code is "Unable to find part of path 'N:\7- PRODUCTION\2-Prep\5-Follow-up Performance CUP 2023. xlsx'".

It means that the gateway can not access to the path .For this error code , you need to check:
(1)The machine where the gateway is installed has access to this directory.You just have to make sure that all three of these exist on the machine where the gateway is installed.

(2)This folder can be accessed by the gateway service account.

For this , you can refer to :
Change the on-premises data gateway service account | Microsoft Learn

(3)Connection paths in datasets can only be modified if they are parameterized or republished. Modifying the path in the credentials does not modify the connection path in the dataset.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

View solution in original post

5 REPLIES 5
Tabular3000
New Member

Thought PowerBi would be as awesome as Excel, as new learner this has been a nightmare dedicating hours figuring thing out; once the project is save -- everything is restricted is using GitHub to push the project over to GitHub. Time spent in project that I can spend with my family is what is frustrating.

KoketsoM
Frequent Visitor

Were you able to get around this? I am having the same issue.

Update:

I was able to fix this by getting the full file path name and updating 1. My data source on the pbix, and on connection. so instead of N:\7- PRODUCTION there's a slightly longer file path name, its like N is representative of some other name, I simply had to check this with IT. 

I hope that helps.

v-yueyunzh-msft
Community Support
Community Support

Hi , @Aodren_Collet 

According to your description, the error code is "Unable to find part of path 'N:\7- PRODUCTION\2-Prep\5-Follow-up Performance CUP 2023. xlsx'".

It means that the gateway can not access to the path .For this error code , you need to check:
(1)The machine where the gateway is installed has access to this directory.You just have to make sure that all three of these exist on the machine where the gateway is installed.

(2)This folder can be accessed by the gateway service account.

For this , you can refer to :
Change the on-premises data gateway service account | Microsoft Learn

(3)Connection paths in datasets can only be modified if they are parameterized or republished. Modifying the path in the credentials does not modify the connection path in the dataset.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

@Aodren_Collet 
The error says: Unable to find part of path - This is indicative that the problem has something to do with the file path name you provided. I had the exact same error for an Excel file as well.

I was able to fix this by getting the full file path name and updating:

1. My data source on the pbix.
2. The connection on the powerBI Service. So instead of N:\7- PRODUCTION there's a slightly longer file path name, N is representative of some other name, I simply had to check this with IT- and that did the trick for me!

I hope that helps.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors