Forum Discussion
Utilizing a shared Sharepoint Folder
Hello.
My goal is to create a dashboard that will schedule refresh without the use of a gateway. In order to this, I have been utilizing personal sharepoint files/folders for my data. Now I want to input data from a folder on sharepoint that someone else has shared with me. When following the same steps that I used for my personal files, but with the shared folder, all the data shows is "null". Is there anyway to do this?
Thank you,
Nick
4 Replies
Is the folder on SharePoint Online or SharePoint Server on premises? If it's SharePoint Online you indeed won't need a gateway.
It's hard to know exactly where porting your existing query to the new source fails without screenshots and code samples. I suggest you create a new query from scratch (i.e. from Get Data) that points to the SharePoint folder, then re-create or copy/paste the transformation steps from the previous query, if you're comfortable using the Advanced Editor.
The folder is on SharePoint Online. I tried starting a new query from scratch and tried uploading the data from the folder, but the same problem with "null" data. Could you provide step by step instructions to uploading data from a shared folder (that I am not the owner of) on SharePoint Online to PowerBI? Thank you!
