Forum Discussion
Connecting a network drive to Power BI
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.
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?
6 Replies
- lbendlin
Super User
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?
nathancwatkinsHelper II
Don't click on the "Combine Files" arrows, just click on the green word "Binary". That's your file.
--Nate
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
- Rufyda
I'm glad you found a solution! We're here in the community to support each other.
Regards,
Rufyda Rahma | MIE
