Dataflow Connection to OneDrive Error

[Anonymous]

Hi all,

I am trying to connect a dataflow to some tables in a OneDrive folder but I am getting some connection errors. 

I choose Excel file for the connection. Then for the URL I give the path to the folder. For Authentication Kind I pick Organizational Account and sign in with that account. When I click next it returns the error: An exception occurred: DataFormat.Error: The input URL is invalid. Please provide a URL to the file path on SharePoint up to the file name only

I've tried different formats of the URL, but I can't figure out what it is looking for. If I give the URL for one of the files in the folder directly it returns the error: invalid credentials.

Should I use Authentication Kind: Basic? If so, what is the Username? If I use my org email and password, it returns invalid credentials.

Thanks for any help you can offer me.

[v-yuta-msft]

@Anonymous ,

Currently, the onedrive connector in power bi desktop only support onedrive root URL. Here is the idea about onedrive folder connector, you may vote for this idea. 

In addtion, there's also a workaround which use the onedrive sync in windows. Please refer to this similar thread.

Community Support Team _ Jimmy Tao

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

[Anonymous]

I pasted my excel file to the root OneDrive Buisness folder and right clicked on it and got a link via share. 

When I login with my buisness creddential in the Power BI File importer I get the same error every time I try to create the DataFlow:

Invalid credentials. (Session ID: d2ff58df-21cf-4c66-8725-c3a61982573d)

Same thing happens when I upload it to a sharepoint site and get a link that way. Nothing works. Why is it so incredibly hard to make a dataflow?

[Anonymous]

Sorry I should have specified, I was trying to connect to a OneDrive folder from the PowerBI Service when creating a new dataflow entity. I found a solution though, the folder in OneDrive is labled "Files" but the path is "Documents."