Connecting a network drive to Power BI

[annaRu1]

Hello,

I've been struggling with connecting a network drive from my organization to Power BI. I am using 'Folder' connector. I need to retrieve a file from this drive based on two conditions: the name beginning with 'abcd' and 'data created' the latest. When I am doing the modifications and then Applying changes, I have such an error message:

When I am only doing the filtering to get the needed file and then I click APPLY, I get no errors (like on this screen shot):

But when I try to open the file by clicking on the icon I marked in red

, and then I click APPLY, I constantly get the error above.

[Rufyda]

I'm glad you found a solution! We're here in the community to support each other.

Regards,
Rufyda Rahma | MIE

[nathancwatkins]

Don't click on the "Combine Files" arrows, just click on the green word "Binary". That's your file.

--Nate

[annaRu1]

Hello, 

it does not work, because when I click on the word "Binary", then the chosen file gets hardcoded in the M code like here:

and I need every week to download the latest file, so the name can't be hardcoded.

Regards

[lbendlin · Accepted solution]

A folder needs to be addressed by its full name, like 

\\server\share

Can you confirm that you have that? And that you can access the folder from your file explorer?

[annaRu1]

This worked, thank you. 🙂

[lbendlin]

In your Power Query code sort the files by Last Modified date descending and then grab the binary from 

[Content]{0}

which always gets you the newest file.