Connecting PowerBI-Dataflow to Sharepoint Online List

[waltonb]

Hello,

In PowerBI-Desktop, I connect to files strored in SharePoint folders using the SharePoint folder connector.

I edit the "source" set of the query from SharePoint.Files() to SharePoint.Contents().

The only SharePoint online connectors available in Dataflow appear to be SharePoint lists and I am not able to connect to the discrete files stored wihtin SharePoint folders as I could using PowerBI desktop.

Is there any advise or direction on how I could connect PowerBI-Dataflow to files saved in SharePoint folders??

Thanks in advance.

Braden.

[GilbertQ · Accepted solution]

Hi there

I would suggest connecting to your data in SharePoint using Power BI Desktop and the query editor.

Once that is working, go into the advanced editor and copy the code. Then in the data flows, create a new blank query and paste the code in there.

You then should be able to see your data.

[Anonymous]

Hi, 
That query works in desktop:

let
Source = SharePoint.Contents("https://magentatec.sharepoint.com/sites/magenta-crm-group/", [ApiVersion = 15])
in
Source

But when copied into the dataflows throws a mistake "Unable to create OAuth connection. Reason: "Unexpected error""
Signing In with Microsoft account, both in desktop and dataflows. 

Any ideas how to fix it, please?

[geraldcousi]

Hello, I get the same problem : 

1) copying the M code from PwBI desktop to Dataflow editor :

let
Source = SharePoint.Files("https://mytenantname.sharepoint.com/FOLDERNAME", [ApiVersion = 15]),
#"Lignes filtrées" = Table.SelectRows(Source, each ([Name] = "myexcelfile.xlsx"))
in
#"Lignes filtrées"

2) Trying to connect to sharepoint folder using "Microsoft" authentification :

a pop-up appear and while the Mirosoft user to selectappear in the pop-up, the powerbi window gave an error "Connexion cancelled"

What's wrong ?

Regards.

[waltonb]

Thanks GilbertQ,

Your recommendation seems to work a treat.

Cheers.

[GilbertQ]

Awesome, glad it is now working for you!