DataFlows - OneDrive Personal Connection

[BIBarry]

Hi All, I need help connecting a OneDrive Personal file from dataflows. Current I have connected using a download URL taken from Microsoft Graphs but this will not do as the file I need to connect to is overwritten daily, resulting in a 404(Link Changes).

So I need to connect using the filename(delete.xlsx) in the path, I have used the below to connect to delete.xlsx in the root. Excel.Workbook(Web.Contents("https://api.onedrive.com/v1.0/drives/driveId/root:/delete.xlsx"), null, true)

But this is throwing an error Please specify how to connect, in which I don't know what is causing the problem

If I click edit credentials and Anonymous, it just brings be back to the error?Same happens with Basic Auth and Organ. Auth is not clickable. Is this an issue with the Data Gateway?

Thanks

[v-jiascu-msft]

Hi @BIBarry,

Since the file will be overwritten frequently, I would suggest you use the connector "SharePoint Folder". Please follow the steps below.

1. Connect to the SharePoint Folder in the Desktop and get the desired contents and then copy the Power Query code in the Advanced Editor.

2. Since the Dataflow is under preview, we will do this with a Blank query. Firstly, we need to create a new Dataflow.

3. Create a blank query and paste the code we copied in step 1.

4. Sign in your account and save the Dataflow.

The key point here is creating a new Dataflow without Data Gateway.

Best Regards,
Dale

[ImkeF]

Hi Dale @v-jiascu-msft ,

trying to connect to OneDrive for Business with this method, but still getting authentication error: 

Data source credentials are missing or invalid. Please update the credentials for AzureDataLakeStorage in dataflow settings and try again

Could this be due to multi-factor-authentication enabled?

I'm trying to sign in via OAuth2:

Then pick my account:

and thats it. Nothing more. Getting errors.

And when I edit the credentials to check, they show this:

So to me it looks, as if the auth didn't work.

Any ideas why that is?

Thanks.