Forum Discussion
Community ChampionDataflow Accessing a Sharepoint Folder with an xlsx
Hi DebbieE,
I'd like to suggest you use an excel connector with an excel URL to get data on dataflow.
https://testsite.sharepoint.com/sites/ExampleTeamsFoldername/Shared%20Documents/General/test.xlsx
Reference link:
Use OneDrive for Business links in Power BI Desktop
Regards,Xiaoxin Sheng
I also got around it by doing it in Desktop.
Then in Service creating a blank query and pasting the M Code into this query. Then it worked
You shouldn't need to use a gateway if you're using SharePoint online... If your company is using SharePoint server on-prem, then it will need to go through the gateway.
I have several dataflows connecting to sharepoint lists and folders, and have received the error a couple of times, I usually just need to edit the credentials and make sure that I'm signed in.
Hope that helps!
Kim
- DebbieE
my credentials are fine.
When I log in Via Desktop with the Sharepoint Folder I get no issues.
When I do the same thing in Service I get the error
Hi DebbieE,
I'd like to suggest you use an excel connector with an excel URL to get data on dataflow.
https://testsite.sharepoint.com/sites/ExampleTeamsFoldername/Shared%20Documents/General/test.xlsx
Reference link:
Use OneDrive for Business links in Power BI Desktop
Regards,Xiaoxin Sheng
- DebbieE
I also got around it by doing it in Desktop.
Then in Service creating a blank query and pasting the M Code into this query. Then it worked