Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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?
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.
Thanks GilbertQ,
Your recommendation seems to work a treat.
Cheers.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.