cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Matthias93 Helper III
Helper III

Network path of excels not found

Hi,

 

I'm storing multiple excel files in a document library on SharePoint. I'm connecting to these excels from Power BI desktop. Sometimes out of the blue I will get the error you can see attached to this topic. When I create a new query with the exact same force, everything works perfectly. When I copy the source of this new query to my older one, I however still get the same error message. This message already pops up at the source step of my query. This seems like a very strange error to me. Having to create new queries, visuals and relationships each times this happens would be a real hassle. Has anybody had this issue?

 

Thanks for helping in advance.

 

Kind regards,

Matt

 

 

Capture.PNG

4 REPLIES 4
Matthias93 Helper III
Helper III

Excel source not found

Hi,

 

I'm storing multiple excel files in a document library on SharePoint. I'm connecting to these excels from Power BI desktop. Sometimes out of the blue I will get the error you can see attached to this topic. When I create a new query with the exact same force, everything works perfectly. When I copy the source of this new query to my older one, I however still get the same error message. This message already pops up at the source step of my query. This seems like a very strange error to me. Having to create new queries, visuals and relationships each times this happens would be a real hassle. Has anybody had this issue?

 

Thanks for helping in advance.

 

Kind regards,

Matt

 

Capture.PNG

Microsoft
Microsoft

Re: Network path of excels not found

@Matthias93

 

It looks like the data provider resolves incorrect URL from your older query. Please check compare the difference of two Power Queries, copy the new query and overwrite the older query.

 

Regards,

Snehalg150
Regular Visitor

Re: Network path of excels not found

Hey ,

I also got the same error.

this error occurs due to incorrect URL.

If you are storing excel in the SharePoint ,you will get accurate path by clicking on 3 dots one box will pop up there at the bottom you will get correct path of your excel

Pest that path in the advance query editor.

This solved my error .Hope it will help you  too

Anonymous
Not applicable

Re: Network path of excels not found

Hi @Matthias93

 

I got the same error message when I used the excel connetor to import excel files stored in SharePoint.

In my case, the error message popped up in the query editor, however, it doesn't stop the file from refreshing. For some reason, it shows error in the default preview in the query editor, but the error sign disapeared once I hit the refresh preview button without modifying the query. And it works fine as well if I ignored the error message and refresh the file directly. 

 

I'm suspecting it is because my organization is using an older version SharePoint which may not work perfectly with the latest Power BI. 

 

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors