Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to create a DATAFLOW loading data from an excel file stored in sharepoint online.
As recommended , I've created a query with PwBI desktop (works fine) and copied to a blank query within Dataflow definition in PwBI online :
let
Source = Excel.Workbook(Web.Contents("https://mytenant.sharepoint.com/FOLDER/excelfilename.xlsx"),null,true),
Navigation = Source{[Item = "Sheet 1", Kind = "Sheet"]}[Data]
in
Navigation
Then I'm prompted to enter modify the credentials. I Choose "Professional account", then a popup appear to choose the account name. But while the pop-up appear, then on the original window (pwbi online) the error message appear "Connexion cancelled". Just after the account list appear in the pop-up, but when cliking on it, then the pop-up becoms blank and nothing more.
Any idea ? Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.