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.
Solved! Go to Solution.
That query works in desktop:
Source = SharePoint.Contents("https://magentatec.sharepoint.com/sites/magenta-crm-group/", [ApiVersion = 15])
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?
Hello, I get the same problem :
1) copying the M code from PwBI desktop to Dataflow editor :
Source = SharePoint.Files("https://mytenantname.sharepoint.com/FOLDERNAME", [ApiVersion = 15]),
#"Lignes filtrées" = Table.SelectRows(Source, each ([Name] = "myexcelfile.xlsx"))
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 ?
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.