Forum Discussion
Helper IIICombining tables causing refresh to fail in Power BI Service
GilbertQ Just wanted to let you know I was not able to get it working using the Folder option. I was unable to resolve the access errors. However, I was able to get it to work using the Sharepoint Folder option. They key there is to initially select the SharePoint Site, and then apply to filter to select the individual folder that has my files.
Thanks again for your suggesitons.
Helper IIIHi GilbertQ.
Thanks for the reply. Were you using SharePoint online or on-premise. In my experience, getting files from a folder did not work with on-premise SharePoint.
Super UserHi cmncp
I have done this using On-Premise SharePoint.
I have a blog post below, in which you can follow the steps to get it working.
Power BI – Configuring SharePoint/Folder refreshing using On-Premise Gateway
- cmncp
GilbertQ Very good blog post.
I am having issues trying to set up the gateway. It is telling me the credentials are invalid. I am not the owner of the SharePoint site, but I do have access. In fact I created the folder and copied the files into it.
- GilbertQ
Hi cmncp
Thanks for the comments on the blog post.
I would suggest looking to see what LogOn Account the Power BI Gateway Service is using on the Server.
Once you got the domain account, then add this same domain account into your SharePoint Document Libriary Permissions. If this Domain Account is not in there it will then fail when trying to Add it as a Data Source in the On-Premise Gateway.
Also when you installed the On-Premise Gateway did you install it in Personal Mode or Enterprise mode?
- cmncp
GilbertQ Just wanted to let you know I was not able to get it working using the Folder option. I was unable to resolve the access errors. However, I was able to get it to work using the Sharepoint Folder option. They key there is to initially select the SharePoint Site, and then apply to filter to select the individual folder that has my files.
Thanks again for your suggesitons.